| 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: | 2009-09-30 09:24:16 |
| Message-ID: | 1254302656.10072.3.camel@fsopti579.F-Secure.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | rintaant | 2009-09-30 10:11:52 | Re: INSERT with RETURNING clause inside SQL function |
| Previous Message | 纪晓曦 | 2009-09-30 09:08:35 | Where can I get the number of plans that considered by Planner? |