Oracle | Character Set Functions

Oracle NLS Character Set Functions Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Be sure to view the full listing of monographs in Morgan's Library

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;