Skip to Main Content
Forums

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 11g Case Insensitive Issue

928114Apr 3 2012 — edited Oct 26 2012
Hi,
For our .net framework 4.0 Application we need case insenstive search. So I have tried setting NLS_COMP=LINGUISTIC & NLS_SORT=BINARY_CI in environmental variable.. But this is not working. But when I tried firing trigger on each logon and setting NLS_COMP for each session.. It is working.. But because of performance reason we don't want to fire on trigger for each database logon.

Pls Let me know why it is not working setting environmental variable. We are using Oracle 11g client and 10g server and connecting from our .net application through ODP.NET.


Regards,
Raghu

Comments

gdarling - oracle
Do you see the same behavior when connecting via SQLPlus after setting the environment variables? Is this an ODP.NET specific issue? If it's not specific to ODP, you'll probably get better insight by posting in one of the generic database forums.

With respect to ODP specific solutions, have you already checked out the OracleGlobalization class?
http://docs.oracle.com/cd/B19306_01/win.102/b14307/OracleGlobalizationClass.htm#i1009565

Hope it helps,
Greg
928114
Yes even connecting to SQLPlus having environmental variable setting.. facing same problem.. However on explicitly setting NLS cases insensitive session values on each logon it is working..
Don Kleppinger
We have always used the login trigger to set the NLS settings. Our DBA set this up when we were on 10g and still do it now that we are on 11g. There must have been a reason he set up up using the trigger. Maybe same issue you're having. Since we are using connection pooling anyway I believe the login trigger only fires once anyway and we don't have any performance problems with getting connections.
Don Kleppinger
note that if you use the global NLS setting, all of your indexes on text columns must be function based indexes or they won't be used.
i.e
NLSSORT("FIRST_NAME",'nls_sort=''BINARY_CI''')
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 23 2012
Added on Apr 3 2012
#11g, #odp-net
4 comments
355 views