Re: Disabling case sensitivity - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Disabling case sensitivity
Date
Msg-id 20020711092047.U63911-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Disabling case sensitivity  (ktt <kestutis98@yahoo.com>)
Responses Re: Disabling case sensitivity  ("Arguile" <arguile@lucentstudios.com>)
Re: Disabling case sensitivity  (Adrian 'Dagurashibanipal' von Bidder <avbidder@fortytwo.ch>)
List pgsql-general
On Thu, 11 Jul 2002, ktt wrote:

>
> That's a problem, because I building
> a UNICODE text database and planning case insensitive
> search.

You can do case insensitive searches as long as you're
willing to use something other than var=literal (such
as tolower(var)=lowerliteral or tolower(var)=tolower(literal)
or var ILIKE literal).


pgsql-general by date:

Previous
From: "Linn Kubler"
Date:
Subject: syncronizing databases?
Next
From: Andrew Sullivan
Date:
Subject: brk() function and performance