Re: case insentive
Date: Mon, 15 Sep 2008 19:44:29 +0200
Message-ID: <48ce9fe0$0$40307$4fafbaef@reader5.news.tin.it>
"tiro" <tiro_at_mancino.it> ha scritto nel messaggio
news:48ce9c49$0$40314$4fafbaef_at_reader5.news.tin.it...
>
> "Mark D Powell" <Mark.Powell_at_eds.com> ha scritto nel messaggio
> news: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?
>
>
>
Ok i succeded with this settings
ALTER SESSION SET NLS_COMP=ANSI;
ALTER SESSION SET NLS_SORT=BINARY_CI;
Received on Mon Sep 15 2008 - 12:44:29 CDT