Re: case insentive

From: Mark D Powell <>
Date: Mon, 15 Sep 2008 08:05:20 -0700 (PDT)
Message-ID: <>

On Sep 15, 10:24 am, "gym dot scuba dot kennedy at gmail" <> wrote:
> "tiro" <> wrote in message
> news:48ce6082$0$40304$> Hi.
> > I have to open an ado connection from access toward db oracle 11g
> > It's simple but i have to set oracle db case insensitive
> > How can i set db oracle 11g case insensitive in ado connection?
> You don't.  Unless they changes something in 11g the queries are case
> sensitive with respect to character fields.
> Jim

Actually you can set a session parameter that will provide case insesitive searches and sorts in 10g onwards.

There are also techniques for handing case insesitive searches in lower version such as using function based indexes

Also using functions: upper, lower, transform, etc ....

Linguistic Sorting and searches

HTH -- Mark D Powell -- Received on Mon Sep 15 2008 - 10:05:20 CDT

Original text of this message