RE: FN-FORUM: Oracle - Sensitive Bugger

date posted 7th August 2003 15:32

That won't work. In fact it will generate an error. Putting double
quotes around strings is a MySQL aberation.

IIRC you can setup oracle database to be case insensitive at _install_
time. Ask your DBA. :)

Otherwise just use this common workaround:
lower(lastname) like lower('stOKeS%');

And yes you can convert it to:
lower(lastname) like 'stokes%';

If and only if you trust yourself and the follow on maintainers :)

Cheers,

Dave.

On Thu, 2003-08-07 at 15:33, Craig Tinson wrote:
> Rob..
>
> You *could* (and this is a guess) replace the ' with " 's.. (single
> quote with double)
>
> This is a guess and might not make any difference whatsoever..but worth
> a try..
>
> HTH
>
> 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..
>
> 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
>
> ==========
> 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 46.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
>
>
> ===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 46.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 46.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
>
>
>
>
> =========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 46.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?gb8CDE2FB52A0A16AD4C
>
> To Post a New Message: [EMAIL REMOVED]
> Forum Homepage: http://www.freelancers.net/forum.php
>
> http://www.freelancers.net - freelancers and freelance jobs
>