Re: Case insensitive queries

Galen Boyer wrote:
>
> On Sat, 29 Nov 2003, forbrich_at_tyahoo.net wrote:
> > Daniel Morgan wrote:
> >>
> >> 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.
> >
> > But if it's done at the DB level, the developers can correctly
> > state that the performance issue is not theirs. Thereby
> > shedding their responsibility in the name of doing it 'at
> > internet speed'.
> >
> > (Lousy design is never a possible source of problems. Similar
> > to 'security? naw, no time now! we'll do it later, maybe in
> > production. shouldn't have an impact.')
>
> Please tell me any of this discussion has anything to do with
> lousy design? This "lousy design" mantra is something thrown out
> by people to somehow let their argument have more merit. Where
> is the lousy design in wanting Oracle to remove this limitation?
>

My comments are directly from experience and reflect my frustration with developers in general who haven't bothered to learn how to develop anything past rapid prototyping.

Don't take it personally. Unless the shoe fits. Received on Sat Nov 29 2003 - 12:16:37 CST