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 B60208B9CF6 for ; Tue, 1 Feb 2005 09:50:17 +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 42227-10 for ; Tue, 1 Feb 2005 09:50:13 +0000 (GMT) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by svr1.postgresql.org (Postfix) with SMTP id 795258B9CF3 for ; Tue, 1 Feb 2005 09:50:10 +0000 (GMT) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Tue Feb 01 10:50:09 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 j119o7sG006276 for ; Tue, 1 Feb 2005 10:50:07 +0100 Message-ID: <41FF50CE.76CEB361@rodos.fzk.de> Date: Tue, 01 Feb 2005 10:50:06 +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: case sensitive/insensitive confusion 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.047 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/18 X-Sequence-Number: 20129 I am seeing different ORDER BY results on a character column on different machines. I have (1) ResyDBE=# select version(); version ------------------------------------------------------------------------ PostgreSQL 7.4.5 on hppa-hp-hpux10.20, compiled by GCC gcc (GCC) 3.3.1 ResyDBE=# \l ResyDBE List of databases Name | Owner | Encoding -----------+-------+----------- ResyDBE | rodos | SQL_ASCII ResyDBE=# select parameter_name from parameter_define where parameter_name ilike 'c%' order by 1 limit 8; parameter_name ---------------- CAENAM CAENAM CAENAM CBERRY CBERRY CCCTOG CCCTOG CCCTOG and (2) ResyDBE=# select version(); version ------------------------------------------------------------------------------------- PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1 (SuSE Linux) ResyDBE=# \l List of databases Name | Owner | Encoding -----------+-------+----------- ResyDBE | rodos | SQL_ASCII ResyDBE=# select parameter_name from parameter_define where parameter_name ilike 'c%' order by 1 limit 8; parameter_name ---------------- c12a c12b c12c c1a CAENAM CAENAM CAENAM CAENAM 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. I'd like to see the hpux behaviour under linux too. Has anybody seen something like this? TIA Regards, Christoph