[turba] Case sensitive vs. case insensitive search

Chuck Hagenbuch chuck@horde.org
Tue, 18 Sep 2001 10:57:16 -0400


Quoting Liam Hoekenga <liamr@umich.edu>:

> oracle has functions to conver stuff to all caps, or all lower - upper() and 
> lower() respectively..
> 
> select * from some_table where lower(some_table_field) = 
> lower($some_php_variable)

Okay. Looks like we can do this in Turba. UPPER() and LOWER() seem to be pretty 
standard SQL.

Try the commit I just made.

> this also explains why i had to cover the table and field names to uppercase 
> in horde_prefs (as mentioned in one my posts this weekend on the IMP list)

This, I don't follow - can you explain why these are related?

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"What was and what may be lie, like children whose faces we cannot see, in the 
arms of silence. All we ever have is here, now." - Ursula K. Le Guin