german sort is wrong - Mailing list pgsql-admin

From Reinhard Asmus
Subject german sort is wrong
Date
Msg-id 4F689E94.2090408@spdfraktion.de
Whole thread Raw
Responses Re: german sort is wrong  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Hallo,

i make initdb with --locale='de_DE.utf8'.

the result is:

The database cluster will be initialized with locale de_DE.utf8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "german".

when i make a sort this is the result:

select * from sgvs.test order by bezeichnung;

id | bezeichnung | schlagworte
----+-------------+-------------
  11 | Anton       |
   8 | Ätna        |
  10 | Erna        |
   2 | Kammer      |
   6 | Kanten      |
   1 | Käse        |
   4 | Köbern      |
   3 | Kümmern     |
   5 | Kuno        |
   9 | Möbel       |
   7 | Zuber       |

in german this is wrong. what is the problem?


pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: deciding between amd and intel processor
Next
From: "Kevin Grittner"
Date:
Subject: Re: german sort is wrong