Andreas <[email protected]> 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
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql