Re: Is Oracle is CASE SENSITIVE

I'm with Sybrand here. (Now why isn't that a surprise).

"The world is case-insenstive"

Java case sensitive
Unix case sensitive
etc etc

I gues these systems are just not in the real world then.

It should be self evident that storing data where an a is different from an A is more flexible and therefore more desirable system. the case insensitive world is a subset of the case sensitive world.

Finally how difficult is it really to use your programming language of choice to do string comparisons.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<michaeljenc_at_my-deja.com> wrote in message
news:8tbb82$2o5$1_at_nnrp1.deja.com...


> In article

> <972602198.20813.1.pluto.d4ee154e_at_news.demon.nl>,

>   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl>

> wrote:

> > There is no need to mention that as the world

 (except for the Microsoft


> > empire) is case sensitive.

> > Oracle can't do case insensitive searches. In

 fact, I respond this to this


> > same question several times a week, and it is

 getting a bit boring. A search


> > on deja.com shouldn't  have turned up a blank.

> > You need to

> > - use redundant upper or lower cased columns

 (7.3 and 8.0)


> > - or use function based indexes (Oracle 8i

 *enterprise*)


> > - or wait for someone promoting their OMNIDEX

 product (you would have found


> > that of course with a search on deja also).

> >

> > Regards,

> >

> > Sybrand Bakker, Oracle DBA

> >

>


> A few months ago I also searched for some

> switches how I could make oracel case-

> insensitive. I first could not believe that there

> is no such switch. If I search for a name (ie.

> McGreg) I want to have the results, no matter

> what case it is written in (MCGregor, ...).

> Now I know where all the old fashioned, badly

> readable uppercase word lists come from...

>


> My opinion is that the world is case-insensitive.

> Proof: For PLS/SQL a 'select' is the same

> as 'SELECT'...

>


> In MS SQL Server I think it's a feature that

> seems just essential for a DBMS in today's

> world...

>
>
>


> Sent via Deja.com http://www.deja.com/

> Before you buy.