german sort is wrong

From: Reinhard Asmus <reinhard(dot)asmus(at)spdfraktion(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: german sort is wrong
Date: 2012-03-20 15:13:24
Message-ID: 4F689E94.2090408@spdfraktion.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gary Webster 2012-03-20 19:26:18 clustering with shared storage
Previous Message masterchief 2012-03-18 04:29:04 Warnings in Standby Logs