Skip to Main Content

SQL Developer

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!

Unable to do case-insensitive string comparison using NLS in SQL Developer

726603Nov 9 2009 — edited Dec 10 2009
Hi,
I'm trying to do case-insensitive string comparisons in SQL Developer using NLS_COMP=BINARY_AI; NLS_SORT=LINGUISTIC.

However,

1. setting the NLS params in Tools->Preferences->Database->NLS Parameters seems to have no effect.
2. if I execute ALTER SESSION SET NLS_COMP=LINGUISTIC and ALTER SESSION SET NLS_SORT=BINARY_AI, it appears to be successful, but then my connection gets closed,
which defeats the purpose.

Version: Oracle SQL Developer 1.5.5.59.69

Am I missing something here?


Thanks,
Ben
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2010
Added on Nov 9 2009
2 comments
1,498 views