Re: Very weird problem of "order by" in postgresql - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Very weird problem of "order by" in postgresql
Date
Msg-id 20080909091439.GA29604@svana.org
Whole thread Raw
In response to Re: Very weird problem of "order by" in postgresql  ("Peter Cai" <newptcai@gmail.com>)
List 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.

Attachment

pgsql-general by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: 64-bit Compile Failure on Solaris 10 with OpenSSL
Next
From: Zdenek Kotala
Date:
Subject: Re: 64-bit Compile Failure on Solaris 10 with OpenSSL