Re: Case insensitivity in Oracle 7.3 ???

prochak_at_my-dejanews.com wrote in message <748vq2$aej$1_at_nnrp1.dejanews.com>...
>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"

applying the function upper will cause the index not to be used.
>
>
>>
>> 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 Wed Dec 09 1998 - 10:29:05 CST