Re: problem with nasty latin2 sorting

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Anna Domachowska <anka(at)zjednoczenie(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: problem with nasty latin2 sorting
Date: 2005-12-21 21:59:03
Message-ID: 87slsm863c.fsf@stark.xeocode.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-novice


Anna Domachowska <anka(at)zjednoczenie(dot)com> writes:

> 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.

What does "show lc_collate" say?
What does \l show in psql?

what do you get on your machine if you save that same list in a file and run
"sort" on it on the commandline set (with LC_COLLATE set to the same value as
above)?

--
greg

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-12-21 22:43:38 Re: Automatic function replanning
Previous Message Dave Cramer 2005-12-21 21:37:28 Re: replicating tsearch2 across versions of postgres

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-12-21 23:40:44 Re: [HACKERS] problem with nasty latin2 sorting
Previous Message Brad Nicholson 2005-12-21 20:34:52 Re: Questions about server.