Oracle | Character Set Functions

Oracle NLS Character Set Functions Version 21c

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose These functions are specific to obtaining character set related information. String functions are on a separate page linked at page bottom.

Note

Have you seen the Functions page? If not ... Click Here ... for information on all Oracle functions

Dependencies

STANDARD

NLS_CHARSET_DECL_LEN

Returns the declaration length (in number of characters) of an NCHAR column NLS_CHARSET_DECL_LEN(bytecnt IN NUMBER, csetid IN NUMBER) RETURN PLS_INTEGER;

SELECT  NLS_CHARSET_DECL_LEN(200, nls_charset_id('ja16eucfixed'))

      FROM dual;

NLS_CHARSET_ID

Returns the character set ID number corresponding to character set name string NLS_CHARSET_ID(csetname IN VARCHAR2) RETURN PLS_INTEGER;

SELECT NLS_CHARSET_ID('ja16euc')

      FROM dual;

NLS_CHARSET_NAME

Returns the name of the character set corresponding to ID number number NLS_CHARSET_NAME(csetid IN PLS_INTEGER) RETURN VARCHAR2;

SELECT NLS_CHARSET_NAME(2)

      FROM dual;