Re: case insentive
Date: Tue, 16 Sep 2008 06:49:18 -0700 (PDT)
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