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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ujo Jozef" <ujojozef(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3381: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on 8.2.4
Date: 2007-06-11 15:55:41
Message-ID: 10662.1181577341@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Ujo Jozef" <ujojozef(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Christian Andritzky 2007-06-11 16:25:54 BUG #3382: Service fails to start with option -w
Previous Message Ujo Jozef 2007-06-11 15:33:17 BUG #3381: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on 8.2.4