[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