Re: Ignore capitalization in Oracle 8i?

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Fri, 28 Dec 2001 02:07:43 GMT
Message-ID: <PtQW7.15948$uM.162610_at_rwcrnsc54>


There isn't any.
You have to do select ... from ... where upper(column) = or Like upper(value) (or lower)
I suggest you use host variables for the value. You should be using host variables anyway.
Also create a function based index on the column e.g.
create index blah on foo(upper(mycolumn))... Jim
"Jeffrey Wilke" <jwilke_at_bestweb.net> wrote in message news:3IPW7.84345$BX4.5084672_at_e3500-atl1.usenetserver.com...
> Have you tried changing your nls_order setting in the init.ora file. If it
> is set to BINARY, then the case will matter. I'm not sure what the setting
> is to ignore case.
>
>
> Hope this helps.
>
> Jeff
>
>
> <catherinedevlin_at_toast.net> wrote in message
> news:a0ddcq$l0p$1_at_news.netmar.com...
> >
> > Hi Mike!
> > One possibility is to
> > SET SQLCASE UPPER
> > (or LOWER)
> >
> > - Catherine Devlin
> > http://profiles.yahoo.com/arcticturtle
> >
> > In article <3c1b2a62.65954517_at_news.avnl1.nj.home.com>, <jdoe_at_nospam.com>
> > writes:
> > >What is the way to ignore capitalization when doing a query against
> > >Oracle? I know it can be done because we use a front end system
> > >(written in VB) that connects to an 8i back end has an option that
> > >allows you to ignore capitalization when doing a query. Which means
> > >there is a way to make Oracle ignore case, is it an SQL command? Is
> > >it a setting on the database itself?
> > >
> > >I'm writing an application that has an Access 2000 front end and an 8i
> > >back end and the queries appear to be case sensitive.
> > >
> > >Note: I previously posted this as "case sensitivity in a parameter
> > >query" but I didn't give enough information.
> > >
> > >Thank you,
> > >Mike
> >
> >
> > ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
 eb -----
> > http://newsone.net/ -- Free reading and anonymous posting to 60,000+
 groups
> > NewsOne.Net prohibits users from posting spam. If this or other
 posts
> > made through NewsOne.Net violate posting guidelines, email
> abuse_at_newsone.net
>
>
>
Received on Fri Dec 28 2001 - 03:07:43 CET

Original text of this message