Skip site navigation (1) Skip section navigation (2)

Re: Unicode support

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: Nhan Ngo Dinh <nngodinh(at)tiscali(dot)it>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Unicode support
Date: 2002-02-11 17:22:14
Message-ID: 200202111722.g1BHMFF18273@www1.translationforge (view raw or flat)
Thread:
Lists: pgsql-odbc
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

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-02-12 00:45:42
Subject: Re: Unicode support
Previous:From: Matt WedgwoodDate: 2002-02-09 19:11:44
Subject: Re: Datatype misrepresentation DTS with SQL Server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group