Re: case sensitivity - database setting?

  • From: Dennis Williams <oracledba.williams@xxxxxxxxx>
  • To: cemail_219@xxxxxxxxxxx
  • Date: Mon, 8 Aug 2005 12:51:31 -0500

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 
 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.

Other related posts: