java.sql.SQLException: Illegal mix of collations for operation ‘like‘ 异常

本文主要是介绍java.sql.SQLException: Illegal mix of collations for operation ‘like‘ 异常，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

在做多条件模糊查询的时候，出现了 java.sql.SQLException: Illegal mix of collations for operation 'like' 异常，后经过排查发现为数据库版本问题。

解决方法 : 

        编码格式不统一(只要针对中文汉字)，数据库版问题，因此我们需要在like后面添加关键字binary即可。

<select id="getAllKuCun" resultType="Map">
        select * from jinxiang_repository where
        <if test="condition1!=''">
            code like binary concat(concat("%",#{condition1}),"%") or
            name like binary concat(concat("%",#{condition1}),"%") or
            specifications like binary concat(concat("%",#{condition1}),"%") or
            brand like binary concat(concat("%",#{condition1}),"%") or
            source like binary concat(concat("%",#{condition1}),"%") or
            measurement like binary concat(concat("%",#{condition1}),"%") or
            total like binary concat(concat("%",#{condition1}),"%") or
            price like binary concat(concat("%",#{condition1}),"%") or
            money like binary concat(concat("%",#{condition1}),"%") or
            date like binary concat(concat("%",#{condition1}),"%") or
            contractNumber like binary concat(concat("%",#{condition1}),"%") or
            annotation like binary concat(concat("%",#{condition1}),"%") or
            validity like binary concat(concat("%",#{condition1}),"%") and
        </if>

        <if test="condition2!=''">
            type = #{condition2} and
        </if>
        1=1
        ORDER BY id DESC
</select>

这篇关于java.sql.SQLException: Illegal mix of collations for operation ‘like‘ 异常的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！