Localization problems between Access and PostgresSQL 8 - Mailing list pgsql-general

From Secrétariat
Subject Localization problems between Access and PostgresSQL 8
Date
Msg-id 004501c52896$63db77a0$0a00a8c0@lrp43208
Whole thread Raw
List pgsql-general
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 ?
What kind of encoding must I use to create the PG database under Win XP pro French ?
Thanks for all your comments
Luc

pgsql-general by date:

Previous
From: peter Willis
Date:
Subject: Re: Question about accessing current row data inside trigger
Next
From: Janning Vygen
Date:
Subject: pg_restore: [custom archiver] could not uncompress data: incorrect data check