Sorting Problem in UNICODE/german - Mailing list pgsql-bugs

From Klaus Ita
Subject Sorting Problem in UNICODE/german
Date
Msg-id 20050901110235.GC1479@aipc54.ai.wu-wien.ac.at
Whole thread Raw
Responses Re: Sorting Problem in UNICODE/german  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hi there!

I have a Problem with a DB that was created in UNICODE

* createdb -E UNICODE

and actually shows that it _is_ in UNICODE.
i was able to input data and can read it and everything is fine.
but when i want to "ORDER BY ..." it does not sort the german Umlauts at the
correct postition.

should be:
m n o ö p

and is:
ö a b c d

I have tried starting postgres with LC_ALL=de_AT.utf8@euro
locale but that did not help.

what xould i do?

regs,
klaus

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpgsql TEMP table issue not fixed in 8.1?
Next
From: Tom Lane
Date:
Subject: Re: Sorting Problem in UNICODE/german