My Oracle Support Banner

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 SIA [18361] and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: [18361] Com/Med
Database: Oracle
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***


Hi support,

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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.