Oracle | Character Set Functions

Oracle NLS Character Set Functions Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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;