From: | Anna Domachowska <anka(at)zjednoczenie(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
Subject: | problem with nasty latin2 sorting |
Date: | 2005-12-21 10:01:38 |
Message-ID: | 43A92802.40706@zjednoczenie.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ilias Goudaropoulos | 2005-12-21 11:00:58 | Windows Installer Bug (Probably) |
Previous Message | Martin Pitt | 2005-12-21 08:38:12 | Re: horology regression test failure |
From | Date | Subject | |
---|---|---|---|
Next Message | Tjibbe Rijpma | 2005-12-21 14:48:40 | Re: Small function in PLPGSQL |
Previous Message | Devrim GUNDUZ | 2005-12-21 06:22:16 | Re: Postgresql v 8.0.1-3 problems |