On Thu, 2008-02-21 at 12:01 -0500, Tom Lane wrote: > Pascal Cohen <pcohen@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
