case insentive

#21

On Sep 15, 1:29*pm, "tiro" <t... (AT) mancino (DOT) it> wrote:

Quote:

"Mark D Powell" <Mark.Pow... (AT) eds (DOT) com> ha scritto nel messaggionews:d9c719e4-474f-4f0d-8257-7ccdafb64432 (AT) 79g2000hsk (DOT) googlegroups.com...
On Sep 15, 10:24 am, "gym dot scuba dot kennedy at gmail"<kenned... (AT) verizon (DOT) net> wrote:
"tiro" <t... (AT) mancino (DOT) 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 --

#22

On 15 Sep, 14:15, "tiro" <t... (AT) mancino (DOT) it> wrote:

Quote:

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?

Instead of trying to change the behaviour of the RDBMS, why not just
code appropriately?

HTH

-g

#23

On 15 Sep, 14:15, "tiro" <t... (AT) mancino (DOT) it> wrote:

Quote:

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?

Instead of trying to change the behaviour of the RDBMS, why not just
code appropriately?

HTH

-g

#24

On 15 Sep, 14:15, "tiro" <t... (AT) mancino (DOT) it> wrote:

Quote:

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?

Instead of trying to change the behaviour of the RDBMS, why not just
code appropriately?

HTH

-g

#25

On 15 Sep, 14:15, "tiro" <t... (AT) mancino (DOT) it> wrote:

Quote:

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?

Instead of trying to change the behaviour of the RDBMS, why not just
code appropriately?

HTH

-g

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

case insentive

comp.databases.oracle.misc comp.databases.oracle.misc

Re: case insentive - 09-16-2008 , 08:49 AM

Re: case insentive - 09-17-2008 , 05:03 AM

Re: case insentive - 09-17-2008 , 05:03 AM

Re: case insentive - 09-17-2008 , 05:03 AM

Re: case insentive - 09-17-2008 , 05:03 AM