Re: Case insensitive queries

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 29 Nov 2003 08:43:41 -0800
Message-ID: <1070124251.361117@yasure>

Galen Boyer wrote:

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

>
>
> None. But having to do this is a workaround. Simple. What
> about that is hard to consider?

But a switch in the init.ora that does the same thing isn't? The code above will run on any version of Oracle going back to the stone age. The code you write dependent on the switch will work only if on 10g.

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

I fail to see what the web has to do with it. Please explain the issue.

-- 
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 - 10:43:41 CST