From: | Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz> |
---|---|
To: | Secrétariat <ets(at)rolland-fr(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Localization problems between Access and PostgresSQL |
Date: | 2005-03-15 13:15:56 |
Message-ID: | 4236E00C.4090400@startnet.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 | Content-Type | Size |
---|---|---|
miroslav.sulc.vcf | text/x-vcard | 387 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | sferriol | 2005-03-15 13:16:10 | Internal account lookup failure |
Previous Message | tony | 2005-03-15 13:07:57 | Re: prelimiary performance comparison pgsql vs mysql |