Thread: How configure Oracle 9i not case sensitive...

How configure Oracle 9i not case sensitive...

From
"Eloy Mier Pérez"
Date:
Hi, i would configure Oracle 9i not case sensitive and in the table names
dont use ""...

How can i do this ?

Thanks in advance



Re: How configure Oracle 9i not case sensitive...

From
Hans Forbrich
Date:
Eloy Mier Pérez wrote:

> How can i do this ?

Not possible.

Oracle works upper-case only for dictionary unless using "". Many have found
this to be "a good thing", others think it's a limitation.  Not worth
debating!

Best you learn to code to the documented limits, or switch.

/Hans
Please do not cross post to all these groups.  (Or are you simply trolling
and trying to get a fight between the Oracle and Postgres groups?)


Re: How configure Oracle 9i not case sensitive...

From
sybrandb@yahoo.com
Date:
"Eloy Mier Pérez" <eloy.mier@tantacom.com> wrote in message news:<Ku5ic.115120$Rc.3299230@news-reader.eresmas.com>...
> Hi, i would configure Oracle 9i not case sensitive and in the table names
> dont use ""...
>
> How can i do this ?
>
> Thanks in advance

You can't
Stick to sqlserver.


Sybrand Bakker
Senior Oracle DBA