Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id D1EA22F4278 for ; Wed, 21 Mar 2012 11:24:37 -0300 (ADT) Received: from mail3.dbtg.de ([193.17.243.2]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SAMSl-0007q3-2Y for pgsql-admin@postgresql.org; Wed, 21 Mar 2012 14:24:36 +0000 Received: from mailng04.bundestag.de (b.mx.intern.out [172.16.47.2]) by mail3.dbtg.de (Postfix) with ESMTP id C4E0270021DA for ; Wed, 21 Mar 2012 15:24:16 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mailng04.bundestag.de (Postfix) with ESMTP id C027E1385F80 for ; Wed, 21 Mar 2012 15:24:16 +0100 (CET) X-Virus-Scanned: by amavisd-new at bundestag.de Received: from mailng04.bundestag.de ([127.0.0.1]) by localhost (mailng04.bundestag.btg [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id dHlHBA4trsgf for ; Wed, 21 Mar 2012 15:24:16 +0100 (CET) Received: from mailrelay.spdfraktion.de (unknown [172.22.1.7]) by mailng04.bundestag.de (Postfix) with ESMTP id B007C1385F76 for ; Wed, 21 Mar 2012 15:24:16 +0100 (CET) Received: (qmail 22924 invoked from network); 21 Mar 2012 15:24:16 +0100 Received: from unknown (HELO [172.22.8.132]) ([unknown]) (envelope-sender ) by unknown (qmail-ldap-1.03) with SMTP for ; 21 Mar 2012 15:24:16 +0100 Message-ID: <4F69E402.8030708@spdfraktion.de> Date: Wed, 21 Mar 2012 15:21:54 +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: Re: german sort is wrong References: <4F689E94.2090408@spdfraktion.de> <4F69967A02000025000464DC@gw.wicourts.gov> In-Reply-To: <4F69967A02000025000464DC@gw.wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/119 X-Sequence-Number: 39307 Am 21.03.2012 14:51, schrieb Kevin Grittner: > Reinhard Asmus wrote: > >> when i make a sort this is the result: > >> [vowel with umlaut sorts equal to vowel without] > >> in german this is wrong. what is the problem? > > It appears to be one of three different "right" ways: > > http://en.wikipedia.org/wiki/German_alphabet#Sorting > > Is there a different collation available on your OS to sort names? > > -Kevin > when i make the same thing in oracle i've got =C4tna Anton .... is it possible to get the same with postgresql and when how? Reinhard