nls_sort=binary_ci

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 Received on Wed Nov 29 2006 - 14:33:29 CST