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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #3381: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on 8.2.4
Дата
Msg-id 10662.1181577341@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #3381: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on 8.2.4  ("Ujo Jozef" <ujojozef@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Ujo Jozef"
Дата:
Сообщение: BUG #3381: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on 8.2.4
Следующее
От: "Christian Andritzky"
Дата:
Сообщение: BUG #3382: Service fails to start with option -w