Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Case sensitive "like"
Oracle is case sensitive, and there is no way to get around it. A lot of
people who are used to Access have this question, and unfortunately you can't
change it. And you will need to do an UPPER, not a LOWER.
Beth
In article <3730CAA4.F05_at_xsoft.demon.co.uk>,
gerard <gerard_at_xsoft.demon.co.uk> wrote:
> Hi
>
> Hopefully someone can help
>
> consider "where name like 'fred' . On Access this is case insensitive
> and works well. On Oracle it doesn't.
> I want to avoid using "where lower(name) like 'fred'"
> Is there any way of configuring oracle to always ignore
> case sensitive comparisons.
>
> thanks in anticipation.
>
> gerard heathcote
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed May 05 1999 - 21:34:07 CDT