Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Collation in ORDER BY not lexicographical
- From: Peter Eisentraut <peter_e(at)gmx(dot)net>
- To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
- Cc: Paul Gaspar <devlist(at)revolversoft(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Collation in ORDER BY not lexicographical
- Date: Wed, 30 Sep 2009 12:24:16 +0300
- Message-id: <1254302656.10072.3.camel@fsopti579.F-Secure.com> <text/plain>
On Tue, 2009-09-29 at 03:21 -0600, Scott Marlowe wrote: > On Tue, Sep 29, 2009 at 2:52 AM, Paul Gaspar <devlist(at)revolversoft(dot)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.
- References:
- Collation in ORDER BY not lexicographical
- From: Paul Gaspar
- Re: Collation in ORDER BY not lexicographical
- From: Scott Marlowe
- Collation in ORDER BY not lexicographical
- Prev by Date: Where can I get the number of plans that considered by Planner?
- Next by Date: Re: INSERT with RETURNING clause inside SQL function
- Previous by thread: Re: Collation in ORDER BY not lexicographical
- Next by thread: WITH <table> SELECT * FROM function(<table>) WHERE etc
- Indexes: