Re: Case insensitivity in Oracle 7.3 ???

In your SQL statements use the UPPER( function [or LOWER( if you prefer] every time you compare CHAR or VARCHAR values.

For example, instead of:

Select * from Emp where Emp_name = 'Anderson';

Do this instead:

Select * from Emp where upper(Emp_name) = upper('Anderson');

However, I have been told that doing this will frequently cause the optimizer to ignore an index.

David Pattinson wrote:

> I'd appreciate some advice on how one could go about
> 'faking' case-insensitive columns in a case-sensitive Oracle
> 7.3 database. We are going to migrate our database from a
> case_insensitive SQL Anywhere platform, and we want to store
> the actual case the user typed in, but have case
> insensitivity for purposes of searching/matching.
> I can think of one solution involving adding forced upper
> case columns for indexing and searching of text fields, but
> am hoping that there is a better way...
>
> Regards, David.
Received on Wed Dec 02 1998 - 06:52:09 CST