Re: Latin2 and Unicode problems
От
Grzegorz Mucha
Тема
Re: Latin2 and Unicode problems
Дата
Msg-id
01042007374200.00707@theta
Список
Дерево обсуждения
Re: Latin2 and Unicode problems Grzegorz Mucha <mucher@tigana.pl>
Re: Re: Latin2 and Unicode problems Tatsuo Ishii <t-ishii@sra.co.jp>
Re: Re: Latin2 and Unicode problems Grzegorz Mucha <mucher@tigana.pl>
Re: Re: Latin2 and Unicode problems Tatsuo Ishii <t-ishii@sra.co.jp>
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 ICQ #91619595, tel.(502)261417
----------------------------------------------------------------
Quidquid id est, timeo Danaos et dona ferentes.
Wergiliusz, "Eneida"
В списке pgsql-general по дате отправления
От: Karl DeBisschop
Дата: