case sensitive/insensitive confusion - Mailing list pgsql-sql

From Christoph Haller
Subject case sensitive/insensitive confusion
Date
Msg-id 41FF50CE.76CEB361@rodos.fzk.de
Whole thread Raw
Responses Re: case sensitive/insensitive confusion  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
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
byGCC 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
----------------CAENAMCAENAMCAENAMCBERRYCBERRYCCCTOGCCCTOGCCCTOG

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


pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: BLOBs vs BYTEA
Next
From: Peter Eisentraut
Date:
Subject: Re: case sensitive/insensitive confusion