Re: Case sensitive

I've never quite worked out what 'case insensitive' means. You'll find that, in Oracle, if you do a 'select * from EMP' or a 'SeLeCt * FrOm EmP', it's all the same to Oracle... you'll get the same results every time, which surely means that Oracle is case insensitive out of the box.

Unless... unless.... you are daft enough to create your column names in specified case originally, in which case Oracle does the decent thing and respects the case you asked for.

Hence: create table 'BlAh' (col1 char(4)) ... now requires you henceforth to select * from 'BlAh' (use of quotes not optional). But that's only because you used the case-preserving quotes in the first place.

Now it's unfortunate that converting from (say) Access to Oracle means all column names are case-sensitive. Is there something to switch that behaviour off? Nope. Is that a reason for religiously making sure that all table and column names are upper case before converting? Yup. Do it all the time: You have to, too.

Regards
HJR "Microsoft User" <berdii_at_techemail.com> wrote in message news:a9oor1$lrf$1_at_ail.sri.ucl.ac.be...
> Hi,
>
> Somebody can tell me how to change case sensitive to case insensitive on
an
> installed Oracle 8i
> under windows 2000
>
> Thank you
>
>
Received on Fri Apr 19 2002 - 05:54:55 CDT