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
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later Oracle Database - Standard Edition - Version 10.1.0.2 and later Oracle Database - Personal Edition - Version 10.1.0.2 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!