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

Re: german sort is wrong

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-admin(at)postgresql(dot)org>, "Reinhard Asmus" <reinhard(dot)asmus(at)spdfraktion(dot)de>
Subject: Re: german sort is wrong
Date: 2012-03-22 15:39:53
Message-ID: 4F6B017902000025000465D0@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Reinhard Asmus <reinhard(dot)asmus(at)spdfraktion(dot)de> wrote:
> 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?
 
> 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?
 
PostgreSQL doesn't implement collations itself; it can only use
collations available from your OS.  It appears that your OS is
defaulting to the dictionary collation and you would prefer the
phone book collation.  The Wikipedia link mentions that Windows
provides both collations; I suspect it's not the only OS that does,
but have no direct knowledge about that.
 
Starting in version 9.1 PostgreSQL can support collation overrides,
for example at the column level.  Provided that your OS provides
both, you could use one for your default collation and override that
for specific columns, which sounds like it might make sense for
German.
 
-Kevin

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-03-22 15:49:18
Subject: Re: pg_dump: schema with OID 145167 does not exist
Previous:From: Paul WoutersDate: 2012-03-22 13:54:36
Subject: pg_dump: schema with OID 145167 does not exist

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