Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D05E34760BD for ; Thu, 26 Sep 2002 19:41:35 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 73600475D00 for ; Thu, 26 Sep 2002 19:41:35 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id 812E438165B; Thu, 26 Sep 2002 19:41:34 -0400 (EDT) From: Jochem van Dieten X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Case Sensitive "WHERE" Clauses? Date: Fri, 27 Sep 2002 01:41:33 +0200 Organization: OnLine Internet Lines: 10 Message-ID: References: <200209270133.35024.barwick@gmx.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.tudelft.nl User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en X-Enigmail-Version: 0.65.2.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/373 X-Sequence-Number: 9650 Ian Barwick wrote: > > Anyone know what the ANSI standard is? I don`t recall any other > database apart from MySQL which default to case-insensitive > CHAR or VARCHAR columns. SQL:1999 says collation dependent. Jochem