Re: Mac ordering with locales

On Thu, 2008-02-21 at 12:01 -0500, Tom Lane wrote:
> Pascal Cohen <pcohen(at)wimba(dot)com> writes:
> > The fact is that works on Linux and win but under Mac I always get the
> > ordering with 'default' C locale (I displayed all the lc_* and all are
> > right set)
>
> Yeah, this has been complained of before, eg here
> http://archives.postgresql.org/pgsql-general/2005-11/msg00047.php
> and here
> http://archives.postgresql.org/pgsql-general/2004-04/msg00564.php
>
> It seems to be a deficiency in Apple's locale support. The second
> message is interesting since it indicates that "smart" sorting is
> available somewhere/somehow under OS X, but nobody here knows how
> to get at it :-(

I have looked for a standard related to the locale behavior and I was
surprised that I couldn't find one. Is a given locale, e.g. en_US,
supposed to have identical behavior on any platform for which it's
available?

If there is a standard of some kind, is apple violating it?

Regards,
Jeff Davis