Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Case sensitive
You will have a far better experience with Oracle if you don't treat it as SQL
Server sold by another company. I would urge you to learn the way Oracle was
designed to be used and use it in that way.
Daniel Morgan
Forced Microsoft User wrote:
> 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 - 10:54:26 CDT