problem with nasty latin2 sorting

Поиск
Список
Период
Сортировка
От Anna Domachowska
Тема problem with nasty latin2 sorting
Дата
Msg-id 43A92802.40706@zjednoczenie.com
обсуждение исходный текст
Ответы Re: problem with nasty latin2 sorting  (Greg Stark <gsstark@mit.edu>)
Re: problem with nasty latin2 sorting  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hello,
I've got a problem with sorting polish words in postgresql 7.4.2

For example, I've got couple of polish cities in my table 'x', results 
of sorting are:
(select city from x order by city asc)

Bydgoszcz
Gdańsk
Iława
Łódź
Żarnów
Malbork
Warszawa

So "Żarnów" is placed in wrong place, because it should be found after 
letter "Z" ??

What's wrong? Is there any patch to fix this? Does anybody had similar 
problem?
I belive that postgres was compiled with "--enable-locale", and the 
right locale is set.

Anna Domachowska


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: [pgadmin-hackers] Client-side password encryption
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: where is the output