Oracle NLS Character Set Functions
Version 18.1.0.0

General Information
Library Note Morgan's Library Page Header
Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.
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;

Related Topics
Built-in Functions
Character Sets
Operators (Built-in)
Regular Expressions
Undocumented Oracle
UTL_GDK
What's New In 12cR2
What's New In 18cR1

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved