Thread: Localization problems between Access and PostgresSQL 8

Localization problems between Access and PostgresSQL 8

From
Secrétariat
Date:

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

Re: Localization problems between Access and PostgresSQL

From
Miroslav Šulc
Date:
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

Attachment

Re: Localization problems between Access and PostgresSQL

From
tony
Date:
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