Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
problem with nasty latin2 sorting
- 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: Wed, 21 Dec 2005 11:01:38 +0100
- Message-id: <43A92802(dot)40706(at)zjednoczenie(dot)com>
Hello, I've got a problem with sorting polish words in postgresql 7.4.2For 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 WarszawaSo "Ż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
- Follow-Ups:
- Re: problem with nasty latin2 sorting
- From: Tom Lane
- Re: problem with nasty latin2 sorting
- From: Greg Stark
- Re: problem with nasty latin2 sorting
- Prev by Date: Re: status of concurrent VACUUM patch ...
- Next by Date: Windows Installer Bug (Probably)
- Previous by thread: I am back online again
- Next by thread: Re: problem with nasty latin2 sorting
- Indexes: