資料庫字符集修改函式function nls_charset_id_name

wisdomone1發表於2010-06-24
 
#提取utf8字符集的十六進位制編碼
SQL> select to_char(nls_charset_id('utf8'),'xxxx') from dual;
TO_CHAR(NL
----------
  367
 
 
#反向提取utf8字符集十六進位制
SQL> select nls_charset_name(to_number('0367','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('0367','XXXX'))
--------------------------------------------------------------------------------
UTF8
SQL> select nls_charset_name(to_number('367','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('367','XXXX'))
--------------------------------------------------------------------------------
UTF8

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-666078/,如需轉載,請註明出處,否則將追究法律責任。

相關文章