我们使用MySQL 5.6.30-76.3-log。MySQL系统变量设置了utf8:SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%' :
+--------------------------+-----------------+
| 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 |
| collation_connection | utf8_general_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
+--------------------------+-----------------+
但从Python 2.7.6脚本创建触发器时,我看到了该触发器的另一个字符集:
字符集客户端拉丁1
校对连接拉丁语1瑞典语
数据库\u排序规则utf8 \u unicode_ci
请建议如何更改触发器定义中的字符集客户端、排序规则连接到utf8。在