Re: Ignoring Case in String Searches

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: Thu, 14 May 1998 01:47:59 GMT
Message-ID: <355a4cda.2256122@newshost.interact.net.au>

On Wed, 13 May 1998 02:50:19 GMT, "Steve Emmons" <semmons_at_net.bluemoon.net> wrote:

>We are creating a powerbuilder application that has string searching
>functionality. i.e. looking up a company or person in an address book. The
>problem we have is that we are trying to make a database independent
>application and therefore don't want to use the Upper() function in the SQL
>statement since the SQLAnywhere (SQLAnywhere is not case sensitive)database
>doesn't understand this function. Also using the Upper function seems to
>eliminate the use of the Index on the name column.
>
>Is there a way that we can make the database case insensitive. We where
>told by Oracle Support that this could not be done so our thought was to
>make another name column that was in all uppercase and we could use that to
>do the searching.
>
>Any other/better ideas?

Welcome to one of Oracle's big holes. The concept of supporting case insensitivity will bring you nothing but gales of laughter from Oracle.

The dual-storage method (As-entered for display, all-upper for comparison), is the best platform independent method. Go with it.

Ciao
Fuzzy
:-) Received on Wed May 13 1998 - 20:47:59 CDT