Re: Collation in ORDER BY not lexicographical - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Collation in ORDER BY not lexicographical
Date
Msg-id 1254302656.10072.3.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: Collation in ORDER BY not lexicographical  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
On Tue, 2009-09-29 at 03:21 -0600, Scott Marlowe wrote:
> On Tue, Sep 29, 2009 at 2:52 AM, Paul Gaspar <devlist@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.


pgsql-general by date:

Previous
From: 纪晓曦
Date:
Subject: Where can I get the number of plans that considered by Planner?
Next
From: Bronagh Grimes
Date:
Subject: PostgreSQL Macro Query