CONVERT(c1,set1,set2)

【功能】将源字符串c1 从一个语言字符集set2转换到另一个目的set1字符集

【参数】c1,字符串，set1,set2为字符型参数

【返回】字符串

【示例】

select convert('strutz','we8hp','f7dec') "conversion" from dual;

conver
------
strutz

select convert(name,'us7ascii','zhs16cgb231280') "conversion" from dual;