X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 863BDD1D8AE for ; Tue, 10 Feb 2004 06:28:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08925-08 for ; Tue, 10 Feb 2004 02:27:44 -0400 (AST) Received: from mailhub2.une.edu.au (mailhub2.une.edu.au [129.180.4.202]) by svr1.postgresql.org (Postfix) with ESMTP id B7968D1B4BE for ; Tue, 10 Feb 2004 02:27:42 -0400 (AST) Received: from icarus.une.edu.au (icarus.une.edu.au [129.180.47.120]) by mailhub2.une.edu.au (Postfix) with ESMTP id C06336A for ; Tue, 10 Feb 2004 17:27:42 +1100 (EST) Received: from kgb (kgb.une.edu.au [129.180.47.225]) by icarus.une.edu.au (8.12.8/8.12.8) with SMTP id i1A6Sndv024032 for ; Tue, 10 Feb 2004 17:28:49 +1100 Date: Tue, 10 Feb 2004 17:33:43 +1100 From: Klint Gore To: pgsql-general@postgresql.org Subject: Re: Case sensitivity In-Reply-To: <4028740F.7000104@zara.6.isreserved.com> References: <04875CB4331F0240A0AD66F970978651011377D5@paul> <4028740F.7000104@zara.6.isreserved.com> Message-Id: <40287B4736D.5A91KG@129.180.47.120> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Mailer: Becky! ver 1.25.06 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/378 X-Sequence-Number: 57089 On Tue, 10 Feb 2004 13:02:55 +0700, David Garamond wrote: > To be safe, if you want your application to be portable, you should > always assume case-sensitivity. AFAIK, only Access, SQL Server, and > MySQL that are case-insensitive by default while others including > Postgres are case-sensitive. Any other popular DB that are > case-sensitive out there? Sybase SQL Anywhere is not case sensitive by default. It has a setting to change it. klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : kg@kgb.une.edu.au : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+