Search Postgresql Archives

Re: help understanding collation order

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

 



Peter Eisentraut wrote:

> On tis, 2011-01-18 at 10:33 +1100, raf wrote:
> > p.s. if anyone in debian locale land is listening,
> > 'E' does not sort before ','. what were you thinking? :-)
> 
> What is actually happening is that the punctuation is sorted in a second
> pass after the letters.  Which is both correct according to the relevant
> standards and also practical in many situations.

i have no doubt that what you say is true just as i have no doubt that
it is also incorrect and impractical in every situation i'll ever encounter.
i can't imagine ever wanting CLARK to sort both before and after CLARKE.
i'll just re-sort all name-ordered reports in the client. pity.

> It's usually actually the Mac OS X locales that are broken.

only when ignoring the principle of least astonishment. :-)

but it's not the same locale on the two hosts. the macosx
locale is en_AU. the debian locale is en_AU.utf8 so i don't
think they can be compared for brokenness purposes in this case.
they may both be correct.

cheers,
raf


-- 
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