NLS_CHARSET_ID
Syntax
nls_charset_id::=
Description of the illustration nls_charset_id.gif
Purpose
NLS_CHARSET_ID returns the character set ID number corresponding to character set name text. The text argument is a run-time VARCHAR2 value. The text value 'CHAR_CS' returns the database character set ID number of the server. The text value 'NCHAR_CS' returns the national character set ID number of the server.
Invalid character set names return null.
Examples
The following example returns the character set ID of a character set:
SELECT NLS_CHARSET_ID('ja16euc')
FROM DUAL;
NLS_CHARSET_ID('JA16EUC')
-------------------------
830
