One can run into strange sorting issues when using the identity select/search widgets inside the IdentityIQ UI. For example, if the IdentityIQ data is in German, the default Oracle sort order of binary can abort the search and return no values.
Set the following Oracle sorting variables to the following:
NLS_COMP=LINGUISTIC
NLS_SORT=BINARY_CI
Note: The information above applies only to Oracle 11.2.0.2 prior to Patch 25. If you are using Oracle 11.2.02 Patch 25 or later or Oracle 11.2.0.3, this workaround is not required.
The information above applies only to Oracle 11.2.0.2 prior to Patch 25. if you are using Oracle 11.2.02 Patch 25 or later or Oracle 11.2.0.3, this workaround is not required.
We have had these two NLS setting for past few years.
NLS_COMP=LINGUISTIC
NLS_SORT=BINARY_CI
We've upgraded our Oracle DB to 11.2.0.4.
Does it mean we need to or should revert back to using the defaults?
NLS_COMP=BINARY
NLS_SORT=BINARY