Re: unexpected ORDER BY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: unexpected ORDER BY
Date: 2010-11-09 16:10:47
Message-ID: 18805.1289319047@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Andreas <maps(dot)on(at)gmx(dot)net> writes:
> I've got an PG 8.4 on a opensuse box running.
> The DB is unicode german.

> There is a text column I'd like to order by but as far as I see PG
> ignores special chars and uses only characters and numbers.

This is driven by the locale you're using, specifically the LC_COLLATE
setting. If you want "plain ASCII" sort order, you need to switch to
C locale.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bryce Nesbitt 2010-11-10 20:28:46 "slow lock" log in addition to log_min_duration_statement ?
Previous Message Andreas 2010-11-09 16:00:04 unexpected ORDER BY