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.

Uses of Oracle NLS_CHARSET_ID Function
  • Retrieve Character Set ID: Obtain the ID number of a specified character set by its name.

  • Validate Character Set Names: Check if a given character set name is valid by verifying if the function returns a non-null value.

  • Database Configuration: Assist in configuring or querying database settings that depend on character set IDs.

  • Character Set Conversions: Facilitate conversions and operations that require knowing the specific ID of a character set.

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



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/oracle/character-functions/oracle-nls_charset_id-function.php