Re: Unicode support

Le Dimanche 3 Février 2002 21:26, Nhan Ngo Dinh a écrit :
> Any idea?

The only problem is with Arabic, right? Export schema and data separately
from MS SQL Server.

1) Import the schema file in PostgreSQL directly in Latin1.
2) Translate the data file to UFT-8 under Linux using recode or iconv:
- iconv -f arabic_enconding_name -t utf-8 filename.txt
- recode arabic_enconding_name..u8 file_name.txt

A good manual can be found here :
http://www.iro.umontreal.ca/contrib/recode/HTML/recode.html

3) Use pgAdmin2 or pgsql \copy statement to import the file.

Please note that Access2000 and PgAdmin 2 do not support Unicode. This was an
issue for us at pgAdmin Team and the answer is "there is no unicode support
although $M claims there is". You have to wait for Windows ZX 2439, which
will take place in more than 300 years and 134 Windows upgrades. So prepare a
cryogenic place and wait until UTF-8 is added to Access.

On the converse PHP supports unicode very well. Do not hesitate to write me
back for further information.

Cheers,
Jean-Michel POURE