X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D21089FB377 for ; Fri, 18 Aug 2006 10:54:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 60679-04 for ; Fri, 18 Aug 2006 13:54:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from lists.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 660BF9FB1BE for ; Fri, 18 Aug 2006 10:54:33 -0300 (ADT) Received: from alvh.no-ip.org (201-221-217-80.bk12-dsl.surnet.cl [201.221.217.80]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id k7IDsTfm008376; Fri, 18 Aug 2006 06:54:30 -0700 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 8DDCBC2DC66; Fri, 18 Aug 2006 09:54:17 -0400 (CLT) Date: Fri, 18 Aug 2006 09:54:17 -0400 From: Alvaro Herrera To: Erika Terahata Torres Prada e Silva - MPS Cc: pgsql-admin@postgresql.org Subject: Re: RES: Issue on Varchar Ordering Message-ID: <20060818135417.GI32181@alvh.no-ip.org> Mail-Followup-To: Erika Terahata Torres Prada e Silva - MPS , pgsql-admin@postgresql.org References: <5519B95F9CA8B94DA8DE3F0A33375672017BAD10@wtdfl055.prevnet> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5519B95F9CA8B94DA8DE3F0A33375672017BAD10@wtdfl055.prevnet> User-Agent: Mutt/1.5.12-2006-07-14 X-Virus-Scanned: ClamAV version 0.88.3, clamav-milter version 0.88.3 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 18 Aug 2006 06:54:33 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200608/217 X-Sequence-Number: 22760 Erika Terahata Torres Prada e Silva - MPS wrote: > OS Debian 3.1 > > Show lc_collate: > > "pt_BR.ISO-8859-1" > > It returns: > GABRIELA HELEDA DE SOUZA > GABRIELA JACOBY NOS > GABRIEL ALCIDES KLIM PERONDI > GABRIELA LETICIA BATISTA NUNES > GABRIEL ALEXANDRE DA SILVA MANICA > > The correct would be: > > GABRIEL ALCIDES KLIM PERONDI > GABRIEL ALEXANDRE DA SILVA MANICA > GABRIELA HELEDA DE SOUZA > GABRIELA JACOBY NOS > GABRIELA LETICIA BATISTA NUNES > > As I told you, with OS Windows, it works correctly... Strange. I'm using Debian unstable here and it works fine, i.e., just as you expect. This sounds like a glibc bug to me; one corrected after 3.1. (Is that Sarge? I don't know the version numbers.) What version of the libc6 package do you have installed? I have 2.3.6-18 here. $ LC_MESSAGES=C dpkg -l libc6 Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed |/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad) ||/ Name Version Description +++-=======================-=======================-============================================================== ii libc6 2.3.6-18 GNU C Library: Shared libraries -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support