Search Postgresql Archives

Re: help understanding collation order

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jan 17, 2011 at 02:19:14PM -0500, Tom Lane wrote:

> No, not particularly.  Sort order is determined by lc_collate
> not lc_messages.  Unfortunately it's entirely possible that OSX
> will give you a different sort order than Linux even for similarly
> named lc_collate settings.  About the only lc_collate setting that
> really behaves the same everywhere, guaranteed, is "C"

This is partly because of the generous room allowed for linguistic
tailoring in the Unicode standard on collation.  In case one really
wants to have a bad day, I can suggest reading
http://unicode.org/reports/tr10/ carefully.  But they make an
important point there, which is that collation rules work by language,
not by script.  As I understand things, in Postgres's case it's partly
a matter of how strongly your OS cleaves to the locale conventions
that determines how this will work.  (Note that not every database
system relies on the underlying OS's facilities the way Postgres does;
some have an independent collation mechanism.)

Unicode does maintain a locale data repository:
http://cldr.unicode.org/.  You might be able to figure out which of
your systems is not playing nice and complain to the OS vendor.

A


-- 
Andrew Sullivan
ajs@xxxxxxxxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux