mybatis 的 配置文件中 sql 的IFNULL问题

SELECT
            IFNULL(CAST(TRUNCATE(AVG(inflow_cod),2) AS CHAR),'') inflow_cod,
            IFNULL(CAST(TRUNCATE(AVG(inflow_nh),2) AS CHAR),'') inflow_nh,
            IFNULL(CAST(TRUNCATE(AVG(inflow_nh4),2) AS CHAR),'') inflow_nh4,
            IFNULL(CAST(TRUNCATE(AVG(inflow_p),2) AS CHAR),'') inflow_p,
            IFNULL(CAST(TRUNCATE(AVG(inflow_ph),2) AS CHAR),'') inflow_ph,
            IFNULL(CAST(TRUNCATE(AVG(inflow_ss),2) AS CHAR),'') inflow_ss,
            DATE_FORMAT(detail_date, '%Y-%m-%d') date

        FROM
            ws_sewage_monitor 
    
        GROUP BY
            DATE_FORMAT(detail_date, '%d')
        ORDER BY
            date

resultType="map"时 如果IFNULL中前后数据类型不一样会出现取值为乱码的问题  必须是ifnull 中前后数据类型一致

转载于:https://www.cnblogs.com/yujianhuang/p/7146397.html