Re: Case insensitive queries

On Fri, 28 Nov 2003, damorgan_at_x.washington.edu wrote:
> 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?

None. But having to do this is a workaround. Simple. What about that is hard 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.

There are loads of things that Oracle is doing to speed development. This is another thing they should implement to be the "Web database".

-- 
Galen Boyer