My Oracle Support Banner

NLS_LANGUAGE and NLS_TERRITORY Definitions Changed in 10g, 11g and 12c Versus 9i and lower (Doc ID 292942.1)

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database - Standard Edition - Version and later
Oracle Database - Personal Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.


Changes have been made to the content in some of the NLS_LANGUAGE and NLS_TERRITORY definition files in Oracle Database 10g, 11g and 12c when compared to 9i and lower.
These updates are necessary to correct the legacy definitions which no longer meet the local conventions in some of the Oracle supported languages and territories. So some changes were made to correct the definitions used by Oracle's language and territory settings.
It's however possible to use with 10g and higher "9i behavior" definitions. This note includes detailed steps on how to enable this.


Anyone upgrading from 9i to a higher version.


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
 1) List of things that might have changed:
 2) Affected NLS_LANGUAGE definitions:
 3) Affected NLS_TERRITORY definitions (including language variants):
 4) How to use the "9i behavior" definitions.
 4.A) Create the "9i behavior" file set:
 4.B) Enable the Oracle9i behavior:
 5) Testing the 9i behavior file set from a client
 6) Know problems using the "9i behavior" file set.
 7) note that Oracle Applications Release 11i and Release 12 requires the 9i behavior when using an Oracle 10.1 or higher database.
 8) Other new NLS_TERRITORY and  NLS_LANGUAGE additions :

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.