Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: case sensitivity - database setting?
J. Dex
Others have addressed the situation where you are sorting the records. What
I've seen is the situation where you are searching for a particular record.
You end up with the situation with
WHERE UPPER('my search string') = UPPER(column)
As DBA, you can support this by creating a FBI (function-based index) on the
column.
The vendor must support this by including syntax such as the above in the
SQL they create. If the vendor doesn't support this syntax, then your only
alternative is to train your users to enter all data with a consistent case.
Dennis Williams
We are setting up an application (third-party out-of the-box type) and the
> group that is setting it up would like to set it up so that when users
> search for records the searches are NOT case sensitive.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 08 2005 - 12:53:28 CDT