Skip site navigation (1) Skip section navigation (2)

Case Insensitive Searching?

From: "Ben Schneider" <bcschnei(at)attbi(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>, <pgsql-php(at)postgresql(dot)org>
Subject: Case Insensitive Searching?
Date: 2003-05-23 20:24:36
Message-ID: 001301c32169$54d90fa0$5011a8c0@micronpc (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-php
I am working on a project where I am creating a PHP front end to a Postgres
database. The schema is new but the data is old. Meaning I had to convert
the data from the old Informix DB.

 

Anyway all of the existing data is in all upper case. However new data going
in will be in both upper and lower case.(As requested by the customer.)

 

So the question is, how do I perform a case insensitive search? Is there a
DB setting I can set to ignore the case?

 

If not, then an example of some PHP code that can do this would be of a
great help.

 

Thanks,

Ben

 

Responses

pgsql-novice by date

Next:From: papapepDate: 2003-05-24 09:38:54
Subject: Re: Inserting data of two other tables
Previous:From: Tom LaneDate: 2003-05-23 19:31:40
Subject: Re: Inserting data of two other tables

pgsql-php by date

Next:From: Christopher Kings-LynneDate: 2003-05-24 09:03:17
Subject: Re: Number of connections
Previous:From: scott.marloweDate: 2003-05-23 17:53:56
Subject: Re: faster output from php and postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group