My Oracle Support Banner

The National Character Set ( NLS_NCHAR_CHARACTERSET ) in Oracle 9i, 10g , 11g and 12c (Doc ID 276914.1)

Last updated on SEPTEMBER 11, 2023

Applies to:

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

Purpose

This Document provide all the details for National Character Set ( NLS_NCHAR_CHARACTERSET ) in Oracle 9i and up.

Scope

This bulletin provides the Database Administrator a better understanding of National Character Set .

Details

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
Purpose
Scope
Details
 1) What is the National Character Set?
 2) Which datatypes use the National Character Set?
 3) How to know if I use N-type columns?
 4) Should I worry when I upgrade from 8i or lower to 9i, 10g or 11g?
 5) The NLS_NCHAR_CHARACTERSET is NOT changed to UTF8 or AL16UTF16 after upgrading to 9i , 10g (or later).
 6) Can I change the AL16UTF16 to UTF8 / I hear that there are problems with AL16UTF16.
 7) Is the AL32UTF8 problem the same as the AL16UTF16 / do I need the same patches?
 8) But I still want <characterset> as NLS_NCHAR_CHARACTERSET, like I had in 8(i)!
 9) Do i need to set NLS_LANG to AL16UTF16 when creating/using the NLS_NCHAR_CHARACTERSET ?
 10) I try to use AL32UTF8 as NLS_NCHAR_CHARACTERSET but it fails with ORA-12714
 11) I have the message "( possible ncharset conversion )" during import.
 12) Can i use AL16UTF16 as NLS_CHARACTERSET ?
 13) I'm inserting <special character> in a Nchar or Nvarchar2 col but it comes back as ?, � or without accents when selected.
 14) Do i need to change the NLS_NCHAR_CHARACTERSET in 8i to UTF8 BEFORE upgrading to 9i/10g?
 15) Having an UTF8 or AL32UTF8 NLS_CHARACTERSET db is there a advantage to use AL16UTF16 N-types ?
 16) I have a message running DBUA (Database Upgrade Assistant) about NCHAR type when upgrading from 8i .
 17) How to go from an UTF8 NLS_NCHAR_CHARACTERSET to AL16UTF16 NLS_NCHAR_CHARACTERSET?
 18) What is the NLS_SAVED_NCHAR_CS characterset seen in some databases?
 19) Can I load data into Nchar, Nvarchar2 or Nclob using sqlldr or use external tables using N-types?
 20) Known issues
References

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