Thread: unexpected ORDER BY

Hi,

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.
E.g. I get :

S&T C...
S&T E...
STP <-- ???
STP A <-- ???
S&T P...
S&T R...

Can I modify the SELECT or even better switch a global setting that PG 
uses all chars to sort?

Andreas <maps.on@gmx.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