#提取utf8字符集的十六进制编码
SQL> select to_char(nls_charset_id('utf8'),'xxxx') from dual;
TO_CHAR(NL
----------
367
----------
367
#反向提取utf8字符集十六进制
SQL> select nls_charset_name(to_number('0367','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('0367','XXXX'))
--------------------------------------------------------------------------------
UTF8
--------------------------------------------------------------------------------
UTF8
SQL> select nls_charset_name(to_number('367','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('367','XXXX'))
--------------------------------------------------------------------------------
UTF8
--------------------------------------------------------------------------------
UTF8
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-666078/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-666078/