MySQL中文插入字符集设置MySQL数据编码设置，解决insert数据时候，报乱码异常。需要修改数据库编码，表编码，列

现象：

解决方式：

// 查看数据库编码
show VARIABLES like 'character%';
// 修改数据库编码
set character_set_database=utf8;
set character_set_server=utf8;
ALTER DATABASE assistant CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci;
// 修改列的编码
ALTER TABLE assistant.tb_fruugo_order CHANGE report_cname report_cname VARCHAR(255) CHARACTER SET utf8;
ALTER TABLE assistant.tb_fruugo_order CHANGE shipping_method shipping_method VARCHAR(255) CHARACTER SET utf8;
ALTER TABLE assistant.tb_fruugo_order CHANGE status status VARCHAR(64) CHARACTER SET utf8;