X-Original-To: pgsql-novice@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 566BD92506F; Fri, 23 May 2003 16:23:27 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 16489-04; Fri, 23 May 2003 16:23:25 -0400 (EDT) Received: from rwcrmhc52.attbi.com (rwcrmhc52.attbi.com [216.148.227.88]) by developer.postgresql.org (Postfix) with ESMTP id 510F492507B; Fri, 23 May 2003 16:23:25 -0400 (EDT) Received: from micronpc (unknown[207.189.110.29]) by attbi.com (rwcrmhc52) with SMTP id <2003052320232405200ohbuse> (Authid: bcschnei@attbi.com); Fri, 23 May 2003 20:23:24 +0000 Reply-To: From: "Ben Schneider" To: , Subject: Case Insensitive Searching? Date: Fri, 23 May 2003 13:24:36 -0700 Message-ID: <001301c32169$54d90fa0$5011a8c0@micronpc> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0014_01C3212E.A87A37A0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4510 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/219 X-Sequence-Number: 7070 This is a multi-part message in MIME format. ------=_NextPart_000_0014_01C3212E.A87A37A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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. =20 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.) =20 So the question is, how do I perform a case insensitive search? Is there a DB setting I can set to ignore the case? =20 If not, then an example of some PHP code that can do this would be of a great help. =20 Thanks, Ben =20 ------=_NextPart_000_0014_01C3212E.A87A37A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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. Ho= wever 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

 

------=_NextPart_000_0014_01C3212E.A87A37A0--