oracle 字符集/转换函数

用CONVERT(char, dest_char_set [,source_char_set] )函数

 

使用convert 函数

SQL code

<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)

-->SQL> select CONVERT(datatype, 'US7ASCII' ) from BSTH_SYS_FIELD_ALIAS;
 
CONVERT(DATATYPE,'US7ASCII')
--------------------------------------------------------------------------------
gfdfghdf
??
SQL> select CONVERT(datatype, 'ZHS16GBK' ) from BSTH_SYS_FIELD_ALIAS;
 
CONVERT(DATATYPE,'ZHS16GBK')
--------------------------------------------------------------------------------
gfdfghdf
中文