Microsoft is case sensitive too. Try logging into NT with your caps lock
key on.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:8tbp7o$n84$1_at_soap.pipex.net...
> I'm with Sybrand here. (Now why isn't that a surprise).
>
> "The world is case-insenstive"
>
> Java case sensitive
> Unix case sensitive
> etc etc
>
> I gues these systems are just not in the real world then.
>
> It should be self evident that storing data where an a is different from
an
> A is more flexible and therefore more desirable system. the case
insensitive
> world is a subset of the case sensitive world.
>
> Finally how difficult is it really to use your programming language of
> choice to do string comparisons.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> <michaeljenc_at_my-deja.com> wrote in message
> news:8tbb82$2o5$1_at_nnrp1.deja.com...
> > In article
> > <972602198.20813.1.pluto.d4ee154e_at_news.demon.nl>,
> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl>
> > wrote:
> > > There is no need to mention that as the world
(except for the Microsoft
> > > empire) is case sensitive.
> > > Oracle can't do case insensitive searches. In
fact, I respond this to this
> > > same question several times a week, and it is
getting a bit boring. A search
> > > on deja.com shouldn't have turned up a blank.
> > > You need to
> > > - use redundant upper or lower cased columns
(7.3 and 8.0)
> > > - or use function based indexes (Oracle 8i
*enterprise*)
> > > - or wait for someone promoting their OMNIDEX
product (you would have found
> > > that of course with a search on deja also).
> > >
> > > Regards,
> > >
> > > Sybrand Bakker, Oracle DBA
> > >
> >
> > A few months ago I also searched for some
> > switches how I could make oracel case-
> > insensitive. I first could not believe that there
> > is no such switch. If I search for a name (ie.
> > McGreg) I want to have the results, no matter
> > what case it is written in (MCGregor, ...).
> > Now I know where all the old fashioned, badly
> > readable uppercase word lists come from...
> >
> > My opinion is that the world is case-insensitive.
> > Proof: For PLS/SQL a 'select' is the same
> > as 'SELECT'...
> >
> > In MS SQL Server I think it's a feature that
> > seems just essential for a DBMS in today's
> > world...
> >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Fri Oct 27 2000 - 10:01:40 CDT
