mysql在调用存储过程时报以下错误：错误码: 1267_unable to translate sqlexception with error code '-优快云博客

本文解决了一个MySQL中因不同字符集导致的错误问题。错误源于使用了latin1与utf8两种不同的字符集，通过调整数据库、服务器及连接的字符集设置为一致的utf8解决了该问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

碰到这个问题，挺靠谱的。

mysql在调用存储过程时报以下错误：
错误码: 1267
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘locate’
集中有两种字符集

执行：SHOW VARIABLES LIKE ‘character_set_%’查看所有字符集
结果如下：
Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir D:\Wnmp\mariadb\share\charsets\

执行：SHOW VARIABLES LIKE ‘character_set_%’
结果如下：
Variable_name Value
collation_connection utf8_general_ci
collation_database utf8_general_ci
collation_server utf8_general_ci

解决办法：
SET character_set_database =utf8;
SET character_set_results =utf8;
SET character_set_server =utf8;
– SET character_set_system =utf8; /此处utf-8也可以，只读，不能修改/
SET collation_server = utf8_general_ci;
SET collation_database = utf8_general_ci;

SET collation_connection = ‘utf8_general_ci’

网址：http://blog.youkuaiyun.com/Angelaaa_/article/details/53068079