This discussion is archived
4 Replies Latest reply: Oct 26, 2012 11:19 AM by Don Kleppinger RSS

Oracle 11g Case Insensitive Issue

928114 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points