Re: Latin2 and Unicode problems - Mailing list pgsql-general

From Grzegorz Mucha
Subject Re: Latin2 and Unicode problems
Date
Msg-id 01042007374200.00707@theta
Whole thread Raw
In response to Latin2 and Unicode problems  (Grzegorz Mucha <grzegorz.mucha@ecp.pl>)
Responses Re: Re: Latin2 and Unicode problems
List pgsql-general
Well, I didn't state it correctly, then. When I use iso8859-2, Postgres is
compiled with --enable-locale only (though compiling it with UNICODE
support, then creating database with ISO encoding works fine - sorting,
upper/lower case conversion).

However, when creating db with Unicode,  no matter if I try to use
ISO8859-2 or Unicode client encoding, the db doesn't get it right - such
functions as upper/lower etc. give unpredictable results (as the result
 of select upper('some-polish-chars') return even some three-byte unicode
chars). I quite frequently get the following message:

utf_to_latin: could not convert UTF-8 (0xc3a3) ignored
(the Unicode char code varies...)

--
Grzegorz Mucha <mucher@tigana.pl> ICQ #91619595, tel.(502)261417
----------------------------------------------------------------
Quidquid id est, timeo Danaos et dona ferentes.
                    Wergiliusz, "Eneida"

pgsql-general by date:

Previous
From: Karl DeBisschop
Date:
Subject: Re: Changing from default configuration options in 7.1?
Next
From: "Willis, Ian (Ento, Canberra)"
Date:
Subject: RE: Best practice