Re: problem with nasty latin2 sorting - Mailing list pgsql-hackers

From Greg Stark
Subject Re: problem with nasty latin2 sorting
Date
Msg-id 87slsm863c.fsf@stark.xeocode.com
Whole thread Raw
In response to problem with nasty latin2 sorting  (Anna Domachowska <anka@zjednoczenie.com>)
List pgsql-hackers
Anna Domachowska <anka@zjednoczenie.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



pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: replicating tsearch2 across versions of postgres
Next
From: Bruce Momjian
Date:
Subject: Re: Automatic function replanning