Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 465C34766BD for ; Thu, 26 Sep 2002 18:58:59 -0400 (EDT) Received: from post.webmailer.de (natpost.webmailer.de [192.67.198.65]) by postgresql.org (Postfix) with ESMTP id 4FE0847628D for ; Thu, 26 Sep 2002 18:58:54 -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 AAA03193; Fri, 27 Sep 2002 00:58:54 +0200 (MET DST) Content-Type: text/plain; charset="iso-8859-1" From: Ian Barwick To: Jordan Reiter , pgsql-sql@postgresql.org Subject: Re: Case Sensitive "WHERE" Clauses? Date: Fri, 27 Sep 2002 01:00:14 +0200 X-Mailer: KMail [version 1.4] References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200209270100.14503.barwick@gmx.net> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/344 X-Sequence-Number: 9621 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: mysql> create temporary table foo (ch char(2), vc varchar(2)); Query OK, 0 rows affected (0.12 sec) mysql> insert into foo values ('aa','AA'); Query OK, 1 row affected (0.02 sec) mysql> select * from foo where ch =3D 'aa'; +------+------+ | ch | vc | +------+------+ | aa | AA | +------+------+ 1 row in set (0.01 sec) mysql> select * from foo where ch =3D 'AA'; +------+------+ | ch | vc | +------+------+ | aa | AA | +------+------+ 1 row in set (0.00 sec) mysql> select * from foo where vc =3D 'aa'; +------+------+ | ch | vc | +------+------+ | aa | AA | +------+------+ 1 row in set (0.00 sec) Regards Ian Barwick barwick@gmx.net