Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 18F4AFA6B99 for ; Thu, 22 Mar 2012 07:27:08 -0300 (ADT) Received: from mail3.dbtg.de ([193.17.243.2]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SAfEX-0006Ce-VQ for pgsql-admin@postgresql.org; Thu, 22 Mar 2012 10:27:07 +0000 Received: from mailng04.bundestag.de (b.mx.intern.out [172.16.47.2]) by mail3.dbtg.de (Postfix) with ESMTP id 56CEF7002CD4 for ; Thu, 22 Mar 2012 11:26:53 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mailng04.bundestag.de (Postfix) with ESMTP id 5709310FA747 for ; Thu, 22 Mar 2012 11:26:53 +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 65tF9+8hIHaN for ; Thu, 22 Mar 2012 11:26:53 +0100 (CET) Received: from mailrelay.spdfraktion.de (unknown [172.22.1.7]) by mailng04.bundestag.de (Postfix) with ESMTP id 46CFD10FA740 for ; Thu, 22 Mar 2012 11:26:53 +0100 (CET) Received: (qmail 3370 invoked from network); 22 Mar 2012 11:26:53 +0100 Received: from unknown (HELO [172.22.8.132]) ([unknown]) (envelope-sender ) by unknown (qmail-ldap-1.03) with SMTP for ; 22 Mar 2012 11:26:53 +0100 Message-ID: <4F6AFDDE.1030401@spdfraktion.de> Date: Thu, 22 Mar 2012 11:24:30 +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/112 X-Sequence-Number: 39300 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