Re: Case Sensetive database property

On Wed, 21 Nov 2001 20:44:33 +0300, "AuRoom Group" <moiseyev_at_hotmail.ru> wrote:

>Hello ALL!
>
>Can anybody help me.
>I have the problem with the SELECT .. WHERE.
>I want to know is there a database option that can set CASE (IN)SENSITIVE
>for WHERE condition for string comparison
>
>Thanks
>
>Konstantin
>

There is not. Only Microsoft's Evil Empire which definitely wants to rule the whole world, is case insensitive. The real world is case sensitive.
Various solutions exist and have been posted many times in this group, so I have to repeat the general recommendation to search the archives at http://groups.google.com before you start posting. For the interim, there are three solutions 1 use where upper(column_name)=upper(:bindvariable) will usually result in a full table scan 2 Have redundant columns with the uppercase variant and index those columns (usually there is no need at all to allow case-insensitive searches on all columns)
3 (*Oracle 8i _Enterprise Edition_ only) create a function based index on the affected column and set query_rewrite_enabled to true

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Nov 21 2001 - 12:16:39 CST