java usascii 转 utf8,从utf8转到US7ASCII

数据库A为UTF8字符集。

数据库B为US7ASCII字符集。

数据库A端，根据基表建立视图，使用到utl_raw.cast_to_raw函数：

CREATE or replace VIEW B$APP_CLOT_INFO AS SELECT

ID,

GMT_CREATE,

utl_raw.cast_to_raw(CREATOR) AS CREATOR,

GMT_MODIFIED,

utl_raw.cast_to_raw(MODIFIER) AS MODIFIER,

IS_DELETED,

utl_raw.cast_to_raw(NAME) AS NAME,

SQL,

utl_raw.cast_to_raw(OBJ_CLASS_NAME) AS OBJ_CLASS_NAME,

utl_raw.cast_to_raw(KEY_NAME) AS KEY_NAME,

utl_raw.cast_to_raw(PARENT) AS PARENT,

utl_raw.cast_to_raw(GROUPS) AS GROUPS,

utl_raw.cast_to_raw(SCHEDULE_STR) AS SCHEDULE_STR,

LOAD_ORDER,

utl_raw.cast_to_raw(COMMENTS) AS COMMENTS

FROM APOLLO.APP_CLOT_INFO;

数据库B端：

SELECT ID,

GMT_CREATE,

convert(utl_raw.cast_to_varchar2(CREATOR), 'zhs16gbk', 'utf8') AS CREATOR,

GMT_