Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 81B704759FC for ; Thu, 20 Jun 2002 11:27:16 -0400 (EDT) Received: from mail.libertyrms.com (unknown [216.94.172.167]) by postgresql.org (Postfix) with ESMTP id 8DDE447647F for ; Thu, 20 Jun 2002 11:13:29 -0400 (EDT) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 17L3cq-0006ub-00 for ; Thu, 20 Jun 2002 11:13:32 -0400 Date: Thu, 20 Jun 2002 11:13:32 -0400 From: Andrew Sullivan To: pgsql-general@postgresql.org Subject: Re: Case sensitivity Message-ID: <20020620111332.F22277@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , pgsql-general@postgresql.org References: <20020620195306.B25394@voxel.cse.iitb.ac.in> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20020620195306.B25394@voxel.cse.iitb.ac.in>; from varunk@cse.iitb.ac.in on Thu, Jun 20, 2002 at 07:53:06PM +0530 X-Archive-Number: 200206/825 X-Sequence-Number: 25974 On Thu, Jun 20, 2002 at 07:53:06PM +0530, Varun Kacholia wrote: > Hi, > Well while moving from Mysql to POstgresql this was one more difference > : Case Sensitivity. > The problem is in this query > select * from table where name='Word' > select * from table where name='word' > > Mysql treated both as same Really!? Wow. Is there a way to differentiate 'Word' from 'word', then? (I mean, LeBlanc and Leblanc are not the same, when you're addressing people. And if you think the difference isn't important, you've never been to Acadia!) > it is good but is there a way that 'Word' can be matched with 'word'? Sure. Use ILIKE: SELECT * FROM table WHERE name ILIKE 'word'; A -- ---- Andrew Sullivan 87 Mowat Avenue Liberty RMS Toronto, Ontario Canada M6K 3E3 +1 416 646 3304 x110