| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Peter Cai <newptcai(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Very weird problem of "order by" in postgresql |
| Date: | 2008-09-09 09:14:39 |
| Message-ID: | 20080909091439.GA29604@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zdenek Kotala | 2008-09-09 09:25:51 | Re: 64-bit Compile Failure on Solaris 10 with OpenSSL |
| Previous Message | Zdenek Kotala | 2008-09-09 09:10:21 | Re: 64-bit Compile Failure on Solaris 10 with OpenSSL |