Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group