Re: Oracle is only case sensitive ?????

Hanne Iren Midttun wrote:

> But, what is a password then?
>
> eg: alter user system identified by bigBandA;
> sqlplus system/bigbanda
>
> This works fine for me. (8.1.7.4 and AIX 4.3)
>
> regards Hanne
> --
> Hanne Midttun
> http://www.tihlde.org/~hannem
>
> English is not my native tounge
>
> On Mon, 17 Feb 2003, Niall Litchfield wrote:
>
> > I suspect that the answers to what you are asking are respectively Yes and
> > then No.
> >
> > Oracle is case insensitive for identifiers i.e
> >
> > select * from scott.emp; is the same as
> > select * from SCOTT.emP;
> >
> > but case sensitive for data, that is
> >
> > 'McDonald' is not the same as 'mcdonald'
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > "Mauro" <benedetto_at_XXXXBluXP.com> wrote in message
> > news:XY74a.16790$uA5.418938_at_tornado.fastwebnet.it...
> > > Is Oracle 8i only Case-Sensitive??
> > > Does not exist a parameter in database creation or installation for permit
> > > case insensitive.
> > >
> > > thanks
> > > Mauro
> > >
> > >
> >
> >
> >

It is NOT a string comparison any more than CREATE TABLE xyz and CREATE TABLE XYZ constitutes a string comparison.

Daniel Morgan Received on Tue Feb 18 2003 - 08:44:02 CST