Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle case in sensitive
use the query as:
select * from customers where UPPER(some_value)
=Upper(some_case_sensitive);
This will give you caseinsensetive searches. Or
you can convert everything through your
application to upper/lower case before conducting
the search.
Manish
In article <911t35$m0t$1_at_nnrp1.deja.com>,
sundarkumar_at_my-deja.com wrote:
> Hi Everyone
>
> I want to make oracle case insensitive meaning,
if I fire a sql query
> like
>
> Ex : select * from customers where
some_value=some_case_sensitive;
>
> So this query will pick up only the matched
some_case_sensitive value. I
> don't want it to be checked for case sensitives.
>
> Ex "junk"="JUNK" - this data not get returned
if I fire the above sql
> becoz by default sql will pickup the exact
match value. I don't want
> this should not be checked. If I looking for
junk, it
> should take all junk case in sensitive values
and return it to me.
>
> I am sure there is some parameter to set and
achieve this. Pls help me
> out in this issues...
>
> Thanx in Advance...
>
> Sundar
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com
http://www.deja.com/
Received on Sat Dec 16 2000 - 15:05:06 CST