Localization problems between Access and PostgresSQL 8

Secr�tariat wrote:

Hello,
I've dumped the content of MS-Access 2002 SP3 tables on a PC with
Windows XP Pro in French localization.
Then I COPY these files, on the same PC hosting an PostgreSQL 8.0.1
database.
I've problems with the accents !? Why ?

Luc, what encoding did you set for your PostgreSQL database? Did you set
client encoding in the dump file to the Frech encoding that your Windows
use?

What kind of encoding must I use to create the PG database under Win
XP pro French ?

I think you shouldn't use Unicode if you need correct collating order.
In this case you should use French encoding aswell (my opinion).

Thanks for all your comments
Luc

Miroslav

Le mardi 15 mars 2005 ￜ 13:52 +0100, Secrￜtariat a ￜcrit :

I've dumped the content of MS-Access 2002 SP3 tables on a PC with
Windows XP Pro in French localization.
Then I COPY these files, on the same PC hosting an PostgreSQL 8.0.1
database.
I've problems with the accents !? Why ?
What kind of encoding must I use to create the PG database under Win
XP pro French ?

I always create my database as -E LATIN1 because I have a mix of server
versions and OS on client and server (Macs mostly). This is the only way
I have managed to keep everything clean. I use functions in my JSPs to
get the right accents in output.

http://www.fracdespaysdelaloire.com database links on the bottom of the
page are an example of JSP accessing French text in PostgreSQL with data
being input from Macs. We use a mix of OpenOffice.org and pgaccess with
no accent problems.

Salut

Tony