Re: german sort is wrong

From: Reinhard Asmus <reinhard(dot)asmus(at)spdfraktion(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: german sort is wrong
Date: 2012-03-21 14:21:54
Message-ID: 4F69E402.8030708@spdfraktion.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Am 21.03.2012 14:51, schrieb Kevin Grittner:
> Reinhard Asmus<reinhard(dot)asmus(at)spdfraktion(dot)de> wrote:
>
>> when i make a sort this is the result:
>
>> [vowel with umlaut sorts equal to vowel without]
>
>> in german this is wrong. what is the problem?
>
> It appears to be one of three different "right" ways:
>
> http://en.wikipedia.org/wiki/German_alphabet#Sorting
>
> Is there a different collation available on your OS to sort names?
>
> -Kevin
>
when i make the same thing in oracle i've got

Ätna
Anton
....

is it possible to get the same with postgresql and when how?

Reinhard

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Paul Wouters 2012-03-21 15:23:45 pg_dump: schema with OID 145167 does not exist
Previous Message Kevin Grittner 2012-03-21 13:51:06 Re: german sort is wrong