Which are the supported values for NLS_SORT Oracle parameter
Last updated on APRIL 30, 2018
Applies to:Siebel System Software - Version 188.8.131.52 SIA  and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 184.108.40.206  Com/Med
Database: Oracle 220.127.116.11
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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms