Oracle is case insensitive in the table name. For sybase, the default is
case sensitive but you can set the character set to case insensitive.
I haven't tried logging into Oracle Database on NT with caps lock.
Fri, 27 Oct 2000 15:01:40 GMT Terry Dykstra <dontreply_tdykstra_at_cfol.ab.ca> wrote:
> 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.
>>
>>
>
>
--
e-Consultant
http://www.asl.com.hk/employment.htm
http://www.eroom.com
Received on Tue Oct 31 2000 - 10:30:00 CST
