| 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: | Whole Thread | Raw Message | 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?
| 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 |