Re: Case sensitivity when searching for and displaying data - Mailing list pgsql-php

From Rod Taylor
Subject Re: Case sensitivity when searching for and displaying data
Date
Msg-id 1062631083.84626.2.camel@jester
Whole thread Raw
In response to Case sensitivity when searching for and displaying data  (Lynna Landstreet <lynna@gallery44.org>)
List pgsql-php
On Wed, 2003-09-03 at 18:31, Lynna Landstreet wrote:
> Hello,
>
> I've gotten a simple PHP search page working on the artists database that
> I've been developing these past few months, but I'm running into a few
> problems with PostgreSQL's case sensitivity.
>
> Ideally I'd like the search text to case insensitive, so that if the user
> enters "jane smith", "Jane Smith" or "JANE SMITH", they'll still find the
> record for Jane Smith. But I'm not sure how to do that.

SELECT * FROM table WHERE upper(column) = upper('search value');

> Secondly, the case sensitivity thing is also messing up the order of the

SELECT * FROM table ORDER BY upper(column);


Attachment

pgsql-php by date:

Previous
From: Robby Russell
Date:
Subject: Re: Case sensitivity when searching for and displaying data
Next
From: "Luis H"
Date:
Subject: Re: Case sensitivity when searching for and displaying data