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?

"tiro" <tiro (AT) mancino (DOT) it> wrote

sensitive with respect to character fields.
Jim

"tiro" <tiro (AT) mancino (DOT) it> wrote

sensitive with respect to character fields.
Jim

"tiro" <tiro (AT) mancino (DOT) it> wrote

sensitive with respect to character fields.
Jim

"tiro" <tiro (AT) mancino (DOT) it> wrote

sensitive with respect to character fields.
Jim

On Sep 15, 10:24*am, "gym dot scuba dot kennedy at gmail"
<kenned... (AT) verizon (DOT) net> wrote:
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/B....htm#sthref608

Also using functions: upper, lower, transform, etc ....

Linguistic Sorting and searches
http://download.oracle.com/docs/cd/B....htm#NLSPG0051

HTH -- Mark D Powell --

On Sep 15, 10:24*am, "gym dot scuba dot kennedy at gmail"
<kenned... (AT) verizon (DOT) net> wrote:
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/B....htm#sthref608

Also using functions: upper, lower, transform, etc ....

Linguistic Sorting and searches
http://download.oracle.com/docs/cd/B....htm#NLSPG0051

HTH -- Mark D Powell --

On Sep 15, 10:24*am, "gym dot scuba dot kennedy at gmail"
<kenned... (AT) verizon (DOT) net> wrote:
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/B....htm#sthref608

Also using functions: upper, lower, transform, etc ....

Linguistic Sorting and searches
http://download.oracle.com/docs/cd/B....htm#NLSPG0051

HTH -- Mark D Powell --

On Sep 15, 10:24*am, "gym dot scuba dot kennedy at gmail"
<kenned... (AT) verizon (DOT) net> wrote:
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/B....htm#sthref608

Also using functions: upper, lower, transform, etc ....

Linguistic Sorting and searches
http://download.oracle.com/docs/cd/B....htm#NLSPG0051

HTH -- Mark D Powell --

"Mark D Powell" <Mark.Powell (AT) eds (DOT) com> ha scritto nel messaggio
news: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:

alter session set nls_comp=ansi

but it seems it doesn't success in oracle 11g
What i did wrong?