My Oracle Support Banner

Troubleshooting RDBMS (client and server) NLS Problems (Charactersets, sorts, dates, ..) (Doc ID 788931.1)

Last updated on AUGUST 23, 2023

Applies to:

Oracle Database - Standard Edition - Version 9.2 and later
Oracle Database - Enterprise Edition - Version 9.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


To provide a starting point in how to debug database client and/or server NLS (globalization) issues, including:

* Problems with setting/defining a NLS parameter
* Client side display of characters.
* Database side storage of characters.
* Database Characterset conversion.
* Problems with Date and sysdate not correct.
* Problems with Timezones and DST.
* Problems with sorting (using NLS_SORT).

And to list the main entry notes who describe each situation

 *** ***

Troubleshooting Steps

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
Troubleshooting Steps
 Instructions for the Reader
 Step by step approach
 Diagnostic Tools
 NLS starting notes to resolve problems:

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