java连接Oracle读取数据返回中文乱码问题

Question

mybatis-plus配置双数据源后，解决Oracle中文乱码的配置失效了，怎么办。

  datasource:
    dynamic:
      primary: master
      strict: false
      druid:
        db-type: com.alibaba.druid.pool.DruidDataSource
        connection-properties: serverEncoding=ISO-8859-1;clientEncoding=GBK;
      datasource:        
        master:
          url: jdbc:wrap-jdbc:filters=encoding:jdbc:oracle:thin:@192.168.6.100:1521/oracl
          username: zhaobn
          password: zbh
          driver-class-name: oracle.jdbc.driver.OracleDriver
          type: com.alibaba.druid.pool.DruidDataSource
        work:
          url: jdbc:wrap-jdbc:filters=encoding:jdbc:oracle:thin:@192.168.6.101:1521/oracl
          username: zhaobn
          password: zbh
          driver-class-name: oracle.jdbc.driver.OracleDriver

Answer 1

引自讯飞星火
在mybatis-plus配置双数据源后，如果遇到Oracle中文乱码的问题，可以尝试以下方法解决：

1. 修改数据库连接的字符集为UTF-8。在创建Oracle数据库时，可以设置字符集为UTF-8。例如：

CREATE DATABASE your_database_name CHARACTER SET UTF8 COLLATE UTF8_GENERAL_CI;

1. 修改MyBatis-Plus的配置文件（如application.yml或application.properties），将spring.datasource.druid.connection-properties中的serverEncoding和clientEncoding的值都改为UTF-8：

spring:
  datasource:
    dynamic:
      primary: master
      strict: false
      druid:
        db-type: com.alibaba.druid.pool.DruidDataSource
        connection-properties: serverEncoding=UTF-8;clientEncoding=UTF-8;
      datasource:        
        master:
          url: jdbc:wrap-jdbc:filters=encoding:jdbc:oracle:thin:@192.168.6.100:1521/oracl
          username: zhaobn
          password: zbh
          driver-class-name: oracle.jdbc.driver.OracleDriver
          type: com.alibaba.druid.pool.DruidDataSource
        work:
          url: jdbc:wrap-jdbc:filters=encoding:jdbc:oracle:thin:@192.168.6.101:1521/oracl
          username: zhaobn
          password: zbh
          driver-class-name: oracle.jdbc.driver.OracleDriver

1. 如果问题仍然存在，可以尝试在查询语句中使用NLS_LANG参数来指定字符集。例如：

SELECT * FROM your_table_name WHERE your_column_name = NLS_LANG('SIMPLIFIED CHINESE_CHINA.ZHS16GBK');

希望以上方法能帮助你解决问题。