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

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Gary WebsterDate: 2012-03-20 19:26:18
Subject: clustering with shared storage
Previous:From: masterchiefDate: 2012-03-18 04:29:04
Subject: Warnings in Standby Logs

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