Re: Latin2 and Unicode problems

Поиск
Список
Период
Сортировка
От Grzegorz Mucha
Тема Re: Latin2 and Unicode problems
Дата
Msg-id 01042007374200.00707@theta
обсуждение исходный текст
Ответ на Latin2 and Unicode problems  (Grzegorz Mucha <grzegorz.mucha@ecp.pl>)
Ответы Re: Re: Latin2 and Unicode problems  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Karl DeBisschop
Дата:
Сообщение: Re: Changing from default configuration options in 7.1?
Следующее
От: "Willis, Ian (Ento, Canberra)"
Дата:
Сообщение: RE: Best practice