Re: Case insensitivity in Oracle 7.3 ???

In article <366537F8.18A098A8_at_Feist.Com>,   KeyStrk_at_Feist.Com wrote:
> 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.

                                change "frequently" to "always"

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

This makes me wonder. What do people do in SQL Anywhere or other case insensitive product to perform a case sensitive search? How do you sort out lets say: Name, NAME or name??

(eg a business name might be all caps: PROCHAK while a personal name is mixed: Prochak but both are in the phone numbers table.)

--
Ed Prochak
Magic Interface, Ltd.
440-498-3702

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Dec 04 1998 - 09:40:50 CST