Oracle NLS Character Set Functions
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers? Software Defined Servers can improve performance and security while lowering complexity and cost. With Software Defined Servers you define servers with an optimum configuration to your environment rather than being memory starved and cpu over-provisioned. Find out how you can improve your computing environment with TidalScale. your friends.
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-2019 Daniel A. Morgan All Rights Reserved