X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DD46A528C7 for ; Fri, 10 Jun 2005 09:21:51 -0300 (ADT) 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 08683-09 for ; Fri, 10 Jun 2005 12:21:50 +0000 (GMT) Received: from ds528.dedicated.turbodns.co.uk (ds528.dedicated.turbodns.co.uk [81.21.72.118]) by svr1.postgresql.org (Postfix) with ESMTP id CB276528B1 for ; Fri, 10 Jun 2005 09:21:49 -0300 (ADT) Received: (qmail 66244 invoked from network); 10 Jun 2005 12:23:40 -0000 Received: from howard.cole@selestial.com by ds528.dedicated.turbodns.co.uk by uid 1005 with qmail-scanner-1.22 ( Clear:RC:1(62.3.231.11):. Processed in 0.019778 secs); 10 Jun 2005 12:23:40 -0000 Received: from unknown (HELO ?10.202.6.101?) (selestial-howard.cole@62.3.231.11) by ds528.dedicated.turbodns.co.uk with SMTP; 10 Jun 2005 12:23:40 -0000 Message-ID: <42A985F8.4010503@selestial.com> Date: Fri, 10 Jun 2005 13:22:16 +0100 From: Howard Cole User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: 'PgSql General' Subject: Case sensitivity Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/591 X-Sequence-Number: 79299 Has case sensitivity changed between 8.0.1 and 8.0.3 or am I missing some setting somewhere? I try the following sql on two database servers and get different results: create table test (val varchar(10)); insert into test values ('A'); insert into test values ('a'); select * from test where val < 'a'; Results on 8.0.1 linux server (UNICODE) val ----- (0 rows) Results on 8.0.3 windows server (UNICODE) val ----- A (1 row) I am guessing that the 8.0.3 on windows is the correct version - but what changes this and how can I set it? regards Howard Cole www.selestial.com