Re: case sensitivity and searching

[prev] [thread] [next] [Date index for 2004/12/06]

On Mon, Dec 06, 2004 at 02:55:18PM -0000, Sandra Crowther wrote:
> If I use CDBIs search_like it is case sensitive.

That's a database specific thing. On MySQL, for example, it isn't.

> My idea was to use the set_sql method to write my own query uppercasing
> the search term via perl and uppercasing the column data via sql (using
> 'upper' as I'm on oracle).

Does Oracle have a case insensitive search operator? If so you can write
your own on-line method that calls it ...

Tony