Postgres Pro
Downloads
Home   >   mailing lists

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

From Kevin Grittner
Subject Re: german sort is wrong
Date
Msg-id 4F69967A02000025000464DC@gw.wicourts.gov
Whole thread Raw
In response to german sort is wrong  (Reinhard Asmus <reinhard.asmus@spdfraktion.de>)
Responses Re: german sort is wrong  (Reinhard Asmus <reinhard.asmus@spdfraktion.de>)
Re: german sort is wrong  (Reinhard Asmus <reinhard.asmus@spdfraktion.de>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Reinhard Asmus
Date:
Subject: german sort is wrong
Next
From: Reinhard Asmus
Date:
Subject: Re: german sort is wrong