Re: [SQL] unexpected ORDER BY

Andreas 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 s

[SQL] 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 t