NLS_CHARSET_ID

Purpose

The NLS_CHARSET_ID function returns the character set ID corresponding to a character set name.

Syntax

NLS_CHARSET_ID(string)

Parameters

The string parameter is a string of any character set.

• When CHAR_CS is passed in: returns the ID of the current database's default character set.
• When NCHAR_CS is passed in: Returns the ID of the current database's national character set.
• If the input name is invalid, NULL is returned.

Examples

obclient> SELECT NLS_CHARSET_ID('ja16euc') 
  FROM DUAL; 

The return result is as follows:

+---------------------------+
| NLS_CHARSET_ID('JA16EUC') |
+---------------------------+
|                      803  |
+---------------------------+
1 row in set (0.001 sec)