X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6E4098B9E4A for ; Tue, 1 Feb 2005 11:44:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58585-09 for ; Tue, 1 Feb 2005 11:44:16 +0000 (GMT) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by svr1.postgresql.org (Postfix) with SMTP id 8E0038B9E22 for ; Tue, 1 Feb 2005 11:44:16 +0000 (GMT) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Tue Feb 01 12:44:15 2005 +0100 Received: from rodos.fzk.de (resy6.fzk.de [141.52.68.10]) by resy5.fzk.de (8.12.7/8.12.7/SuSE Linux 0.6) with ESMTP id j11BiEsG007276 for ; Tue, 1 Feb 2005 12:44:14 +0100 Message-ID: <41FF6B8D.E1010AEA@rodos.fzk.de> Date: Tue, 01 Feb 2005 12:44:13 +0100 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: case sensitive/insensitive confusion References: <41FF50CE.76CEB361@rodos.fzk.de> <200502011114.00969.peter_e@gmx.net> Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS - amavis-milter (http://www.amavis.org/) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.042 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/21 X-Sequence-Number: 20132 Peter Eisentraut wrote: > > Christoph Haller wrote: > > It seems to me under hpux the sort is done case sensitive, > > as would one expect on SQL_ASCII encoding, whereas > > under linux a case insensitive sort is done. > > The sort order depends entirely on the locale that you specify to initdb > (not the encoding). Please check the documentation there. > > -- > Peter Eisentraut > http://developer.postgresql.org/~petere/ > Under hpux I see pg_controldata $PGDATA ... LC_COLLATE: C LC_CTYPE: C Under linux I see pg_controldata $PGDATA ... LC_COLLATE: en_US LC_CTYPE: en_US That explains the confusion, even to me. Thanx to Peter for the quick reply. Regards, Christoph