Re: Case insensitive queries

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 28 Nov 2003 22:18:38 -0800
Message-ID: <1070086746.642557@yasure>

Galen Boyer wrote:

> On Fri, 28 Nov 2003, damorgan_at_x.washington.edu wrote:
>

>>Galen Boyer wrote:

>
>

>>>Sure, the data is case-sensitive, but it would be damn nice
>>>for the database to allow the developer the ability to turn it
>>>off or on based on query needs.
>>
>>I disagree completely. When 10g is released I will advise my
>>students to never use the option for case insensitive queries.

>
>
> How then should they get a case-insensitive query to execute?
> Would you want them to do it the old-fashioned way..., and how
> old-fashioned should it be?

And which part of UPPER(x) = UPPER(y) is to radical to consider?

What is it you think Oracle is doing under the covers to make case insensitive queries possible? Give it some thought. There is no other way to compare byte values than to alter them. A switch in the init.ora does not change what is happening.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sat Nov 29 2003 - 00:18:38 CST