Re: german sort is wrong - Mailing list pgsql-admin

From Reinhard Asmus
Subject Re: german sort is wrong
Date
Msg-id 4F69E402.8030708@spdfraktion.de
Whole thread Raw
In response to Re: german sort is wrong  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: german sort is wrong  (BGoebel <b.goebel@prisma-computer.de>)
List pgsql-admin
Am 21.03.2012 14:51, schrieb Kevin Grittner:
> Reinhard Asmus<reinhard.asmus@spdfraktion.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


pgsql-admin by date:

Previous
From: Gordon Shannon
Date:
Subject: Re: New role can connect to all dbs with no grants
Next
From: "Paul Wouters"
Date:
Subject: pg_dump: schema with OID 145167 does not exist