Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 78ABC476465 for ; Thu, 26 Sep 2002 19:32:41 -0400 (EDT) Received: from post.webmailer.de (natpost.webmailer.de [192.67.198.65]) by postgresql.org (Postfix) with ESMTP id 6C258476443 for ; Thu, 26 Sep 2002 19:32:40 -0400 (EDT) Received: from ianb.local (pD9E0EC7D.dip.t-dialin.net [217.224.236.125]) by post.webmailer.de (8.9.3/8.8.7) with ESMTP id BAA16643; Fri, 27 Sep 2002 01:32:14 +0200 (MET DST) Content-Type: text/plain; charset="iso-8859-1" From: Ian Barwick To: Chris , pgsql-sql@postgresql.org Subject: Re: Case Sensitive "WHERE" Clauses? Date: Fri, 27 Sep 2002 01:33:35 +0200 X-Mailer: KMail [version 1.4] References: <5.1.0.14.0.20020927090709.02f125d0@cooee.squiz.net> In-Reply-To: <5.1.0.14.0.20020927090709.02f125d0@cooee.squiz.net> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200209270133.35024.barwick@gmx.net> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/347 X-Sequence-Number: 9624 On Friday 27 September 2002 01:14, Chris wrote: > >On Thursday 26 September 2002 19:54, Jordan Reiter wrote: > > > Are string comparisons in postgresql case sensitive? > > > >Yes, unless you specify otherwise. > > > >Are you sure you are using the right database? I can > >reproduce similar results, but only like this: > > You're using MySQL in these examples .. not Postgres :) Full points for paying attention ;-) This, erm, characteristic of the former caused me a lot of grief once... 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. Ian Barwick barwick@gmx.net