|
|
 |
RE: FN-FORUM: Oracle - Sensitive Bugger
date posted 7th August 2003 15:13
There must be some reason behind it; can't see why the world's most
reputable database vendor would do something just to be awkward!
It is a pain though... I'll have to do some string manipulating in
ColdFusion methinks.
Cheers anyway,
Rob
-----Original Message-----
From: Craig Tinson [EMAIL REMOVED]
Sent: 07 August 2003 3:36 pm
To: Stokes,RD,Rob,XGF3A STOKESRD C
Subject: RE: FN-FORUM: Oracle - Sensitive Bugger
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
=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
|
|
|
