mysql调用存储过程出现Illegal mix of collations错误

执行sql语句正常

执行存储过程异常

提示

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

解决办法

CREATE PROCEDURE `proce_test`(admin_name VARCHAR(32) charset utf8)

问题描述：MySQL进行字符串比较时发生错误：

错误如下：

解决方法：将比较等式一边进行字符串转换，如改为“CONVERT(b.fullCode USING utf8) COLLATE utf8_unicode_ci”

SELECT

    a.equ_no,

    b.fullCode

FROM

    equipment a,

    (

        SELECT

            t.*, getEquTypeFullCode (t.equType_id) AS fullCode

        FROM

            equ_type t

    ) b

WHERE

    substring(a.equ_no, 1, 5) = CONVERT(b.fullCode USING utf8) COLLATE utf8_unicode_ci;

巴特西

mysql调用存储过程出现Illegal mix of collations错误

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

最新文章

热门文章