Re: Localization problems between Access and PostgresSQL - Mailing list pgsql-general

From Miroslav Šulc
Subject Re: Localization problems between Access and PostgresSQL
Date
Msg-id 4236E00C.4090400@startnet.cz
Whole thread Raw
In response to Localization problems between Access and PostgresSQL 8  (Secrétariat <ets@rolland-fr.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: tony
Date:
Subject: Re: prelimiary performance comparison pgsql vs mysql
Next
From: sferriol
Date:
Subject: Internal account lookup failure