Which are the supported values for NLS_SORT Oracle parameter (Doc ID 541314.1)

Last updated on MARCH 02, 2017

Applies to:

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


Symptoms

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

Cause

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