Hi,

I am having issues with nls_sort=binary_ci, nls_sort setting is not
sorting rows in case insensitive

Oracle 10g R2
Linux x86

steps I followed

alter system set nls_sort=binary_ci scope=spfile;
create pfile from spfile;
shutdown immediate;
startup open;

Here is the sample data after the setting

ACTION_ID ACTION_NAME PD_ID PD_NAME

166 Admin::AdminEditRole 773 SPrivileges
166 Admin::AdminEditRole 774 SPrivileges
166 Admin::AdminEditRole 775 sNewRoleName
166 Admin::AdminEditRole 775 sOriginalRoleName


I WANT THE DATA TO BE SORTED LIKE THIS

ACTION_ID ACTION_NAME PD_ID PD_NAME

166 Admin::AdminEditRole 775 sNewRoleName
166 Admin::AdminEditRole 775 sOriginalRoleName
166 Admin::AdminEditRole 774 SPrivileges
166 Admin::AdminEditRole 773 SPrivileges



Thank you in advance
RA