I finally use a JDBC client to insert the data to the database. But I found it is more convenient if we can insert the
datadirectly using psql. Any way to specific the Unicode character just like Java using \u ?
Anthony
> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: Wednesday, April 17, 2002 5:28 PM
> To: Anthony; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Insert Unicode
>
>
> Le Mardi 16 Avril 2002 08:23, Anthony a écrit :
> > I have created a UNICODE database using the 7.2.1. But I am not
> sure how to
> > prepare an insert script to insert double byte unicode data
> (e.g. Chinese)
> > to the tables. I tried to run the script under PGAdminII and also psql
> > directly but always encounter problem say invalid UNICODe. Any escape
> > character required?
>
> Dear Anthony,
>
> pgAdmin2 is not multi-byte safe due to Visual Basic limitations.
>
> On the converse, it is possible to use pgAdmin2 to design and
> manage a Unicode
> database, provided that you automatically recode data client-side to a
> supported charset (Latin9 for example as it support the euro
> symbol). Just
> enter SET CLIENT_ENCODING = 'Latin9' in pgAdmin2 query editor.
>
> To view Unicode data under Windows, the only solution is to :
> - download and install the latest ODBC multi-byte driver from
> http://odbc.postgresql.org
> - use a unicode compliant application (ex : M$ Access2K).
>
> Cheers,
> Jean-Michel
>