meta property="og:title" content="Oracle NLS_CHARSET_ID function - w3resource"/>
w3resource

Oracle NLS_CHARSET_ID function

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



Share this Tutorial / Exercise on : Facebook and Twitter