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

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-novice by date

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

pgsql-hackers by date

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

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