Unable to do case-insensitive string comparison using NLS in SQL Developer
726603Nov 9 2009 — edited Dec 10 2009Hi,
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