Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id F30A98EF148 for ; Tue, 20 Mar 2012 12:16:01 -0300 (ADT) Received: from mail3.dbtg.de ([193.17.243.2]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SA0n2-0000GK-5s for pgsql-admin@postgresql.org; Tue, 20 Mar 2012 15:16:01 +0000 Received: from mailng02.bundestag.de (b.mx.intern.out [172.16.47.2]) by mail3.dbtg.de (Postfix) with ESMTP id 73A1F7001003 for ; Tue, 20 Mar 2012 16:15:45 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mailng02.bundestag.de (Postfix) with ESMTP id 787D1100BEDB for ; Tue, 20 Mar 2012 16:15:45 +0100 (CET) X-Virus-Scanned: by amavisd-new at bundestag.de Received: from mailng02.bundestag.de ([127.0.0.1]) by localhost (mailng02.bundestag.btg [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id rZs5zGO33kHU for ; Tue, 20 Mar 2012 16:15:45 +0100 (CET) Received: from mailrelay.spdfraktion.de (unknown [172.22.1.7]) by mailng02.bundestag.de (Postfix) with ESMTP id 67E6C100A055 for ; Tue, 20 Mar 2012 16:15:45 +0100 (CET) Received: (qmail 23429 invoked from network); 20 Mar 2012 16:15:45 +0100 Received: from unknown (HELO [172.22.8.132]) ([unknown]) (envelope-sender ) by unknown (qmail-ldap-1.03) with SMTP for ; 20 Mar 2012 16:15:45 +0100 Message-ID: <4F689E94.2090408@spdfraktion.de> Date: Tue, 20 Mar 2012 16:13:24 +0100 From: Reinhard Asmus Organization: SPD Bundestagsfraktion User-Agent: Mozilla/5.0 (X11; Linux i686; rv:10.0.1) Gecko/20120209 Thunderbird/10.0.1 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: german sort is wrong Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/110 X-Sequence-Number: 39298 Hallo, i make initdb with --locale=3D'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 | =C4tna | 10 | Erna | 2 | Kammer | 6 | Kanten | 1 | K=E4se | 4 | K=F6bern | 3 | K=FCmmern | 5 | Kuno | 9 | M=F6bel | 7 | Zuber | in german this is wrong. what is the problem?