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
Дата:
От: Willis, Ian (Ento, Canberra)
Дата:
Сообщение: RE: Best practice
FAQ