2
 Followers
2
 Likes

Performance impact with NLS_SORT= binary

Database
On our radar


Setting the Oracle Parameters for case insensitive searching

We need to set NLS_COMP=LINGUISTIC and NLS_SORT=BINARY_CI in order to use 10gR2 case insensitivity.  Since these are session modifiable, it is not as simple as setting them in the initialization parameters. 

We can set them in the initialization parameters but they then only affect the server and not the client side.  The following PL/SQL was used for a search screen:

execute immediate 'alter session set NLS_COMP=LINGUISTIC';

execute immediate  'alter session set NLS_SORT=BINARY_CI';



Created on 10 Dec 2017
Comments (1)

Hi Vijay,

First of all thank you for your feedback.

Platform uses the following configuration and there is no way to change it.

  • ALTER SESSION SET NLS_COMP=LINGUISTIC NLS_SORT=BINARY_AI

Looking into what you wrote, it seems that you need exactly this. However, in the attached screenshot, is shown something different.

Can you help us to understand a little bit more what is your use case and what you want to achieve?

Cheers

views
245
Followers
2