Re: case insentive
Date: Mon, 15 Sep 2008 08:05:20 -0700 (PDT)
Message-ID: <d9c719e4-474f-4f0d-8257-7ccdafb64432@79g2000hsk.googlegroups.com>
On Sep 15, 10:24 am, "gym dot scuba dot kennedy at gmail"
<kenned..._at_verizon.net> wrote:
> "tiro" <t..._at_mancino.it> wrote in message
>
> news:48ce6082$0$40304$4fafbaef_at_reader5.news.tin.it...> 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 http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_indexing.htm#sthref608
Also using functions: upper, lower, transform, etc ....
Linguistic Sorting and searches
http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch5lingsort.htm#NLSPG0051
HTH -- Mark D Powell -- Received on Mon Sep 15 2008 - 10:05:20 CDT