Howard has given the standard answers (which come up on page one when
searching this group for case insensitive on google) . You can rest assured
there is no such option when installing oracle.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Forced Microsoft User" <berdii_at_techemail.com> wrote in message
news:a9p1om$oku$1_at_ail.sri.ucl.ac.be...
> Great, your two solutions will certainly work fine for me.
>
> I am sure I use it if I don't find any other solution
>
> But I am also using MS SQLSERVER 7.0 and I have installed it with case
> insensitive
>
> here ise a test on my SQL Server databases
>
> create table test (name char(20))
> insert test values ("DAVID SCHUMACHER")
> insert test values ("david schumacher")
> select * from test where name like "D%"
> (select * from test where name like "d%" ) this one gives the same results
>
> --- RESULTS ---
> name
> --------------------
> DAVID SCHUMACHER
> david schumacher
>
> (2 row(s) affected)
>
> This is what I want for my Oracle
>
> Unfortunatly, this is not me who have installed Oracle, and I don't know
if
> during installation there was an option for using databases case-sensitive
> or case-insensitive
>
>
>
Received on Fri Apr 19 2002 - 09:23:35 CDT
