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
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
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics