ORACLE字符集转换 由AL32UFT8至ZHS16GBK

Question

不想用OCI的转换 可以通过映射iconv的字符集来转换吗
如 AL32UTF8对应UTF8 ZHS16GBK对应GBK 直接用iconv函数转换 我发现会报错
报错信息为Invalid or incomplete multibyte or wide character
是映射的字符集不对还是根本不能这样映射

Answer 1

--取两个日期间的工作天数
SELECT COUNT(*) INTO vn
FROM (SELECT vod + ROWNUM - 1 RN
FROM DUAL
CONNECT BY ROWNUM <= vnd - vod)
WHERE TO_CHAR(RN, 'D') BETWEEN 2 AND 6;

--返回数字
RETURN vn;

--异常判断并返回-1
EXCEPTION
WHEN OTHERS THEN
RETURN -1;
END fun_get_workdays;

然后select id,fun_get_workdays(begin_date date, end_date date) from table

Answer 2

SELECT convert('字符串', 'UTF8', 'ZHS16GBK') FROM dual;