Oracle NLS_CHARSET_ID function

Last update on August 19 2022 21:50:41 (UTC/GMT +8 hours)

Description

The Oracle NLS_CHARSET_ID function is used to return the character set ID number corresponding to character set name string.

Invalid character set names return null.

Syntax:

NLS_CHARSET_ID(string)

Parameter:

Name	Description
string	The string argument is a run-time VARCHAR2 value.

Examples: Oracle NLS_CHARSET_ID function

The following example returns the character set ID of a character set:

SELECT NLS_CHARSET_ID('ja16euc') 
FROM DUAL;

Sample Output:

 NLS_CHARSET_ID('JA16EUC')
------------------------- 
                      830

Previous: NLS_CHARSET_DECL_LEN
Next: NLS_CHARSET_NAME