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 laterOracle 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 |