Re: Very weird problem of "order by" in postgresql

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Very weird problem of "order by" in postgresql
Дата
Msg-id 20080909091439.GA29604@svana.org
обсуждение исходный текст
Ответ на Re: Very weird problem of "order by" in postgresql  ("Peter Cai" <newptcai@gmail.com>)
Список pgsql-general
On Tue, Sep 09, 2008 at 09:04:02AM +0800, Peter Cai wrote:
> Oh, you are right!  Although the 'locale' command show that the 2 has the
> same locale settings.
> The sort result of the same file is different.
> Ubuntu is right, centos is wrong??????

Note that glibc uses the information in /usr/share/i18n/locales to
build the relevent tables. Maybe comparing those directories might
help.

There is also a patch to use ICU for collation instead of the OS. That
way you're not tied to any changes your OS might do.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: 64-bit Compile Failure on Solaris 10 with OpenSSL
Следующее
От: Zdenek Kotala
Дата:
Сообщение: Re: 64-bit Compile Failure on Solaris 10 with OpenSSL