今天MySql执行存储过程时,传入表名并创建。但有以下错误
[Err] 1270 - Illegal mix of collations (utf8_general_ci,COERCIBLE), (latin1_swedish_ci,IM
解决方法只需在传入参数后加上charset utf8
CREATE PROCEDURE `proce_test`(admin_name VARCHAR(32) charset utf8)
今天MySql执行存储过程时,传入表名并创建。但有以下错误
[Err] 1270 - Illegal mix of collations (utf8_general_ci,COERCIBLE), (latin1_swedish_ci,IM
解决方法只需在传入参数后加上charset utf8
CREATE PROCEDURE `proce_test`(admin_name VARCHAR(32) charset utf8)