Oracle NLS Character Set Functions
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
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
Analytic Functions
Built-in Functions
CASE
CAST
Character Sets
Collection Functions
Conversion Functions
Data Mining Functions
Date Functions
Miscellaneous Functions
OLAP Functions
Operators (Built-in)
Regular Expressions
REPLACE
String Functions
SUBSTRING
Timestamp Functions
TRANSLATE
Undocumented Oracle
UTL_GDK
XML Functions

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-2014 Daniel A. Morgan All Rights Reserved