Skip site navigation (1) Skip section navigation (2)

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: 2005-12-21 10:01:38
Message-ID: 43A92802.40706@zjednoczenie.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

Responses

pgsql-novice by date

Next:From: Tjibbe RijpmaDate: 2005-12-21 14:48:40
Subject: Re: Small function in PLPGSQL
Previous:From: Devrim GUNDUZDate: 2005-12-21 06:22:16
Subject: Re: Postgresql v 8.0.1-3 problems

pgsql-hackers by date

Next:From: Ilias GoudaropoulosDate: 2005-12-21 11:00:58
Subject: Windows Installer Bug (Probably)
Previous:From: Martin PittDate: 2005-12-21 08:38:12
Subject: Re: horology regression test failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group