#提取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

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

相關文章