Which are the supported values for NLS_SORT Oracle parameter
(Doc ID 541314.1)
Last updated on APRIL 30, 2018
Applies to:Siebel System Software - Version 18.104.22.168 SIA  and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 22.214.171.124  Com/Med
Database: Oracle 126.96.36.199
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|