MySql 编码方式修改

查看存储过程的编码  SHOW CREATE PROCEDURE 存储过程名称

查看数据库库编码

SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';

set character_set_client=utf8;

set character_set_connection=utf8;

set character_set_database=utf8;

set character_set_results=utf8;

set character_set_server=utf8;

set character_set_system=utf8;

set collation_connection=utf8;

set collation_database=utf8;

set collation_server=utf8;

当发生存储过程编码不一致时，查看数据库编码，保持一致后，删除存储过程，重新创建就可以一致了