Dear Serguei. It is strange. Server has encoding as follows.
-- UNICODE --> KOI8R CREATE DEFAULT CONVERSION pg_catalog.utf_8_to_koi8_r FOR 'UNICODE' TO 'KOI8R' FR OM utf8_to_koi8r; -- KOI8R --> UNICODE CREATE DEFAULT CONVERSION pg_catalog.koi8_r_to_utf_8 FOR 'KOI8R' TO 'UNICODE' FR OM koi8r_to_utf8; Please Try psql command. \l <-- list all databases regards Hiroshi Saito ----- Original Message ----- From: "Serguei A. Mokhov" <[EMAIL PROTECTED]> > Hi, > > I think I have a similar issue... A pgAdmin III user contacted me with the > question why they can't see the data in Russian and how to to solve the > problem. I queried them for more information. I think their data must be > encoded in some other encoding (e.g. KOI8-R) and when it gets to the > client side, it's not converted. > > Any other hints aside from below what to try? > > -s > > On Wed, 1 Oct 2003, Jean-Michel POURE wrote: > > > Le Mardi 30 Septembre 2003 17:23, Ã,ngelo Marcos Rigo a écrit : > > > A Portuguese-Brazilian PgAdmin user describe me a > > > problem with acentt code, the data on the database > > > wich have acentt is not displayed properly in PgAdmin > > > III but do appear properly in PgAdmin II. > > > > Hi Ã,ngelo, > > > > Could you: > > - click on the database and show properties. What is the encoding of your > > database: SQL_ASCII or Unicode or anything else? > > > > - send me privately an attached file including the definition of the table > > with one row of data. You can use pg_dump --table=TABLE to dump a table. I > > will test display here. > > > > Are you using our stock binaries or did you compile pgAdmin3 yourself? What OS > > are you running? > > > > Cheers, Jean-Michel > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]