Oracle中如何查看字符char在不同字符集下的编码

Maclean Liu(刘相兵

Oracle中如何查看字符char在不同字符集下的编码

可以使用convert 结合 dump 命令


CONVERT
Converts a character string from one character set to another        CONVERT(<char>, <dest_char_set>, <source_char_set>)
SELECT CONVERT('Ä Ê Í Ó Ø A B C D E','US7ASCII','WE8ISO8859P1')
FROM DUAL;



例如：

select dump(  convert( '天','ZHS16GBK'),16) from dual;
select dump(  convert( '天','AL32UTF8'),16) from dual;

Ling.QIu

CONVERT
http://docs.oracle.com/cd/E11882 ... tions034.htm#i77037
DUMP
http://docs.oracle.com/cd/E11882 ... tions055.htm#i77278