Re: Insert Unicode

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
>