Re: BUG #3381: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on 8.2.4 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3381: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on 8.2.4
Date
Msg-id 10662.1181577341@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3381: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on 8.2.4  ("Ujo Jozef" <ujojozef@gmail.com>)
List pgsql-bugs
"Ujo Jozef" <ujojozef@gmail.com> writes:
> Description:        Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on
> 8.2.4

Your test case works as expected for me.  Maybe there's something hosed
about the locale files on your machine?  Does plain old sort(1) sort the
way you're expecting?  Does "locale -a" agree that you've spelled the
locale name correctly?

Postgres just sorts the way strcoll() tells it to, so unless you've
messed up the database-encoding-vs-locale dependency (which you seem to
have gotten right), wrong sort order really boils down to being a locale
definition issue.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Ujo Jozef"
Date:
Subject: BUG #3381: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on 8.2.4
Next
From: "Christian Andritzky"
Date:
Subject: BUG #3382: Service fails to start with option -w