Thread: Re: [ODBC] pgAdmin2 UTF-8 support
> -----Original Message----- > From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr] > Sent: 25 February 2002 08:51 > To: Dave Page > Cc: pgadmin-hackers@postgresql.org > Subject: Re: [pgadmin-hackers] [ODBC] pgAdmin2 UTF-8 support > > > > OK, what about if you select the data back in pgAdmin - > does it then > > display it? > Sure, it does. This is a new feature of PostgreSQL 7.2. > > > Also, does SET CLIENT_ENCODING SQL_ASCII; work? > No it does not. "é" is stored as 'i'. So, to get this straight in my non multilingual brain, if you set client encoding to latin1 then european charsets (i.e. latin based) work perfectly in pgAdmin? So probably we need to _at least_ do something similar for Japanese/Hebrew etc... /D
Le Lundi 25 Février 2002 10:02, Dave Page a écrit : > So, to get this straight in my non multilingual brain, if you set client > encoding to latin1 then european charsets (i.e. latin based) work perfectly > in pgAdmin? Yes. > So probably we need to _at least_ do something similar for Japanese/Hebrew > etc... Yes. PostgreSQL uses the recode library. Recode can translate UTF-8 to any Windows encoding. i.e, it should be possible to translate UTF-8 (server) to Hebrew (Windows encoding, client), provided that Western VB is able to display Windows Hebrew fonts (which should be the case, no?). Otherwise we will have to ask users of VB localized versions to recompile pgAdmin2. This should work anyway, in one case or another. So users should be able to : - choose client encoding, - choose font for display. Cheers, Jean-Michel
Le Lundi 25 Février 2002 10:02, Dave Page a écrit : > So, to get this straight in my non multilingual brain, if you set client > encoding to latin1 then european charsets (i.e. latin based) work perfectly > in pgAdmin? Have a look at : http://www.postgresql.org/idocs/index.php?multibyte.html#AEN13682 A guy already did what we are looking for : UTF-8 <-> WIN1250 ( Czeck I guess). It should be possible to ask PostgreSQL to recode UTF-8 into : - Japanse Windows, - Chinses Windows, - Hebrew Windows... Recode manual can be found at: http://www.iro.umontreal.ca/contrib/recode/HTML/recode.html