Re: case insentive

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Tue, 16 Sep 2008 06:49:18 -0700 (PDT)
Message-ID: <df032730-3873-43bd-9e94-8f0d9871aa0f@e39g2000hsf.googlegroups.com>


On Sep 15, 1:29 pm, "tiro" <t..._at_mancino.it> wrote:
> "Mark D Powell" <Mark.Pow..._at_eds.com> ha scritto nel messaggionews:d9c719e4-474f-4f0d-8257-7ccdafb64432_at_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
>
> >Actually you can set a session parameter that will provide case
> >insesitive searches and sorts in 10g onwards.
>
> I tried the following statement
>
> alter session set nls_comp=ansi
>
> but it seems it doesn't success in oracle 11g
> What i did wrong?

I think tiro provided the answer. Using the second link I provided there is a table of how the nls parameters affect various Oracle features/functions for sorting/searching for case. ANSI defaults to binary where 'A' <> 'a'.

HTH -- Mark D Powell -- Received on Tue Sep 16 2008 - 08:49:18 CDT

Original text of this message