Which are the supported values for NLS_SORT Oracle parameter
Last updated on MARCH 02, 2017
Applies to:Siebel System Software - Version 126.96.36.199 SIA  and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 188.8.131.52  Com/Med
Database: Oracle 184.108.40.206
Application Server OS: Sun Solaris 2.8
Database Server OS: Sun Solaris 2.8
This document was previously published as Siebel SR 38-2748933453.
***Checked for relevance on 04-Oct-2013***
my customer would like to have the sort type like (1..9, A,a,B,b...Z,z). The oracle support told them that to obtain this behaviour they should change the NLS_SORT database parameter to GENERIC_BASELETTER from BINARY. While till know the application worked with the parameter set to BINARY, I would like to know if now this could cause any problem to system environment. Do you see any side effect to this??
Which are the supported values for this parameter??
PS: I will attach the complete listing of the v$nls_parameters.
Thanks and Regards
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms