mysql怎么改存储过程uft8,将MySQL连接/服务器设置为utf8mb4而不是uft8会破坏SQLYog中的存储过程...

Whether I try to open the stored procedures or create a new one SQLYog is giving the following error:

COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'

They can execute correctly from the server, but on SQLYog they keep giving this error code.

I temporarily solved the issue with SET collation_connection = @@collation_database; but I was wondering if there's a more permanent solution?

解决方案

From SQLyog:

SET NAMES 'utf8mb4' COLLATE 'utf8_bin';

Error Code: 1253

COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'

try:

SET NAMES 'utf8mb4' COLLATE 'utf8mb4_bin';

Using SQLyog Community v12.2.2 (64 bit) and MySQL 5.5.49 can modify (open) and create new stored procedures without problem.

VERSION()

-----------

5.5.49

SET NAMES 'utf8mb4' COLLATE 'utf8mb4_bin';

SET SESSION collation_connection = 'utf8mb4_bin',

collation_server = 'utf8mb4_bin',

collation_database = 'utf8mb4_bin';

SHOW VARIABLES WHERE

`Variable_Name` != 'character_sets_dir' AND

(`Variable_Name` LIKE '%CHAR%' OR

`Variable_Name` LIKE '%COLL%');

Variable_name Value

------------------------ -------------

character_set_client utf8mb4

character_set_connection utf8mb4

character_set_database utf8mb4

character_set_filesystem binary

character_set_results utf8mb4

character_set_server utf8mb4

character_set_system utf8

collation_connection utf8mb4_bin

collation_database utf8mb4_bin

collation_server utf8mb4_bin