mysql 错误码: 1267

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’