一、异常描述
二、解决步骤
1. 查看两数据库字符集情况,如下图所示
2.找到oracle安装路径下配置.ora文件,如$ORACLE_HOME/hs/admin/initmyodbc5.ora
原内容如下[oracle@xoms admin]$ cat initmyodbc5.ora @b@HS_FDS_CONNECT_INFO=myodbc5@b@# Data source name in odbc.ini @b@HS_FDS_SHAREABLE_NAME=/usr/local/unixODBC/lib/libodbc.so @b@HS_FDS_SUPPORT_STATISTICS=FALSE @b@HS_LANGUAGE=AMERICAN_AMERICA.UTF8@b@# ODBC env variables @b@set ODBCINI=/usr/local/unixODBC/etc/odbc.ini
修改后HS_FDS_CONNECT_INFO = myodbc5@b@HS_FDS_TRACE_LEVEL = off@b@HS_FDS_TRACE_FILE_NAME = myodbc5.trc@b@HS_LANGUAGE = AMERICAN_AMERICA.UTF8@b@HS_NLS_NCHAR = UCS2@b@HS_FDS_SHAREABLE_NAME =/usr/local/unixODBC/lib/libodbc.so@b@set LD_LIBRARY_PATH = $LD_LIBRARY_PATH:/usr/lib:/usr/lib64@b@set ODBCINI=/usr/local/unixODBC/etc/odbc.ini
3. 修改后,重启oracle,乱码解决了
4. 如上图因mysql日期使用timestamp和oracle的类型有差异,可以通过如下to_char、to_timestamp方式转换显示select "id","uid","pwd","realName","brand", to_char(to_timestamp("addTime"),'yyyy-mm-dd hh24:mi:ss') from adminusers@mysqltest a