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.

Purpose

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

*** ***