Sorting Problem in UNICODE/german

From: Klaus Ita <postgres(at)stro(dot)at>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Sorting Problem in UNICODE/german
Date: 2005-09-01 11:02:35
Message-ID: 20050901110235.GC1479@aipc54.ai.wu-wien.ac.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)utf8(at)euro
locale but that did not help.

what xould i do?

regs,
klaus

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-09-01 13:30:15 Re: Sorting Problem in UNICODE/german
Previous Message Tom Lane 2005-09-01 02:06:58 Re: plpgsql TEMP table issue not fixed in 8.1?