From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-general@postgresql.org
Subject: Re: Case sensitivity
Date: Thu, 20 Jun 2002 11:13:32 -0400
Message-ID: <20020620111332.F22277@mail.libertyrms.com> (raw)
In-Reply-To: <20020620195306.B25394@voxel.cse.iitb.ac.in>
References: <20020620195306.B25394@voxel.cse.iitb.ac.in>
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
<andrew@libertyrms.info> M6K 3E3
+1 416 646 3304 x110
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: andrew@libertyrms.info
Subject: Re: Case sensitivity
In-Reply-To: <20020620111332.F22277@mail.libertyrms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox