Re: turn off/on case insensetive search in Oracle DBMS

Yes, you could do this - for most developers though this is totally impractical.

It's just another thing that ORACLE doesn't cater for...Ohh, sorry, I mean doesn't lower itself to the level of all the other RDBMS.

.

FB

"Thomas Liang" <liangluosheng_at_china.com> wrote in message news:9jr2nl$hmk$1_at_mail.cn99.com...
> you can write
> SELECT * FROM table WHERE UPPER(field1)='name'
>
> > Hello,
> >
> > we want to do some SQL-statement like 'SELECT FROM table WHERE field1 =
> > "name"' not be affected by case sensitivity as in result we get "name"
> > or "Name". Our actual installation of Oracle 8 works case sensitive.
> >
> > My DBA for our Oracle 8 DBMS told me, that it isn't possible to change
> > this at the server site to "case insensitive".
> >
> > A developer told me, he had read that the server site is configurable
> > for "case insensitive" or "case sensitive" (what we have at the moment).
> >
> > My question: Who is right?
> >
> > Thanks for help
> > Bernd.
> > --
> > Bernd F. Dollinger
> > eMail: Bernd.Dollinger_at_dv-werk.de
>
>
Received on Fri Jul 27 2001 - 08:57:29 CDT