On Tue, 2009-09-29 at 03:21 -0600, Scott Marlowe wrote: > On Tue, Sep 29, 2009 at 2:52 AM, Paul Gaspar <devl...@revolversoft.com> wrote: > > Hi! > > > > We have big problems with collation in ORDER BY, which happens in binary > > order, not alphabetic (lexicographical), like:. > > > > A > > B > > Z > > a > > z > > Ä > > Ö > > ä > > ö > > > > > PG is running on Mac OS X 10.5 and 10.6 Intel. > > I seem to recall there were some problem with Mac locales at some > point being broken. Could be you're running into that issue.
Yes, the UTF8 locales on BSD systems (Mac OS X, FreeBSD, etc.) are dysfunctional. Either switch to a non-UTF8 locale or a different operating system. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general