CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle NLS Character Set Functions
Version 11.1
 
NLS_CHARSET_DECL_LEN
Returns the declaration length (in number of characters) of an NCHAR column NLS_CHARSET_DECL_LEN(<byte_count>, 'character_set_id'>);
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(<string>)
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(<number>);
SELECT NLS_CHARSET_NAME(2)
FROM dual;
 
Related Topics
Character Sets
UTL_GDK
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [59 users online]    © 2010 psoug.org