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 中文