On Thu, 2 Oct 2003, Hiroshi Saito wrote: > From: "Andreas Pflug" <[EMAIL PROTECTED]> > > > Serguei A. Mokhov wrote: > > > > >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. > > > > > > > > This is correctly diagnosed, non-ascii data in a SQL_ASCII encoded > > database will not be shown because the server doesn't know how to > > encode it in Unicode. > > > > This is fixed for HEAD and BRANCH. > > No. > Server encoding as below. > -- SQL_ASCII --> UNICODE > CREATE DEFAULT CONVERSION pg_catalog.ascii_to_utf_8 FOR 'SQL_ASCII' TO 'UNICODE' > FROM ascii_to_utf8; > -- UNICODE --> SQL_ASCII > CREATE DEFAULT CONVERSION pg_catalog.utf_8_to_ascii FOR 'UNICODE' TO 'SQL_ASCII' > FROM utf8_to_ascii;
Yes, I know about existance of this conversion (as well as about the KOI8-R one). It's been there for ages... I'll report back once the user gets back to me on that. I'm not sure though whether they'd be willing to pull the stuff from the CVS and compile it -- even you guys recommend to use the binaries... ;) > regards, > Hiroshi Saito -- Serguei A. Mokhov | /~\ The ASCII Computer Science Department | \ / Ribbon Campaign Concordia University | X Against HTML Montreal, Quebec, Canada | / \ Email! "I swear, education is the only industry, where the consumer is happier when they get less for their money" -- Julia Timofeev ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster