RE: FN-FORUM: Oracle - Sensitive Bugger

date posted 7th August 2003 15:08

I've had a look around google and the general concensus is that this is
a limitation of Oracle.. MSSQL can work in case-sensitive mode.. But it
seems Oracle can't.. Seems a bit like a majorly stupid decision for
Oracle to make (IMHO)..

Cheers

Craig

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
[EMAIL REMOVED]
Sent: Thursday, August 07, 2003 3:27 PM
To: FN-FORUM / [EMAIL REMOVED]
Subject: RE: FN-FORUM: Oracle - Sensitive Bugger



Craig,

Isn't that article all related to Microsoft SQL Server? I'm working with
an Oracle database (which I'm new to!) and I remember reading somewhere
it's case-sensitive by default... hrm...

-----Original Message-----
From: Craig Tinson [EMAIL REMOVED]
Sent: 07 August 2003 3:20 pm
To: Stokes,RD,Rob,XGF3A STOKESRD C
Subject: RE: FN-FORUM: Oracle - Sensitive Bugger



SQL is.. By default case-insensitive..=20

Have a look at
http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

For a few tips/hints/tricks that might be of use to you..

Cheers..

Craig

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
[EMAIL REMOVED]
Sent: Thursday, August 07, 2003 3:12 PM
To: FN-FORUM / [EMAIL REMOVED]
Subject: FN-FORUM: Oracle - Sensitive Bugger



Afternoon all,

Oracle it seems is a bit fussy when it comes to character case: does
anyone know how to 'turn-off' its case-sensitive tendancies, i.e.:

SELECT firstname, lastname from EmployeeTab WHERE lastname like
'stOKeS%';

Would return:

Robert Stokes

Thanks

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
fido.net are pleased to sponsor these Freelancers messages. For all
your web hosting needs check out http://www.fido.net/ with hosting
packages starting from just =A346.95 a year including VAT. Free 0871
Fax2Email numbers also available online! http://www.fido.net/ - the
internet made simple! - 0800 1072 666

To advertise here: http://www.freelancers.net/advertising.html


=3D=3D=3Dfido.net are pleased to sponsor these Freelancers messages. =
For all
your web hosting needs check out http://www.fido.net/ with hosting
packages starting from just =A346.95 a year including VAT. Free 0871
Fax2Email numbers also available online! http://www.fido.net/ - the
internet made simple! - 0800 1072 666

To advertise here: http://www.freelancers.net/advertising.html

Unsub: http://www.freelancers.net/rm.php?g[E8028CDFFE02B4E560

To Post a New Message: [EMAIL REMOVED]
Forum Homepage: http://www.freelancers.net/forum.php

http://www.freelancers.net - freelancers and freelance jobs


fido.net are pleased to sponsor these Freelancers messages. For all
your web hosting needs check out http://www.fido.net/ with hosting
packages starting from just =A346.95 a year including VAT. Free 0871
Fax2Email numbers also available online! http://www.fido.net/ - the
internet made simple! - 0800 1072 666

To advertise here: http://www.freelancers.net/advertising.html

Unsub: http://www.freelancers.net/rm.php?gpE451D1AD0A04611DD3

To Post a New Message: [EMAIL REMOVED]
Forum Homepage: http://www.freelancers.net/forum.php

http://www.freelancers.net - freelancers and freelance jobs