Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: problem with nasty latin2 sorting
Date
Msg-id 17066.1135208444@sss.pgh.pa.us
Whole thread Raw
In response to problem with nasty latin2 sorting  (Anna Domachowska <anka@zjednoczenie.com>)
List pgsql-hackers
Tree view 
Anna Domachowska <anka@zjednoczenie.com> writes:
> I've got a problem with sorting polish words in postgresql 7.4.2
> ...
> I belive that postgres was compiled with "--enable-locale", and the
> right locale is set.

How sure are you of that?  This sure sounds like a wrong-locale problem
to me.  Try "show lc_collate" and "show server_encoding".

            regards, tom lane

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [pgadmin-hackers] Client-side password encryption
Next
From: Simon Riggs
Date:
Subject: Unsplitting btree index leaf pages