Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01 |
|
|
View PDF |
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.
The following example returns the character set ID of a character set:
SELECT NLS_CHARSET_ID('ja16euc') FROM DUAL; NLS_CHARSET_ID('JA16EUC') ------------------------- 830