Mysql 查询编码、转换编码

 -- 查询字段编码
 SHOW FULL COLUMNS FROM temp_ship\G;
 
 -- 查询字段编码
 SHOW FULL COLUMNS FROM tb_info\G;
 
 -- 查询字段编码为utf8_unicode_ci
 ALTER TABLE temp_ship MODIFY COLUMN chip_id VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

 -- 查询字段编码为 utf8_general_ci
 ALTER TABLE temp_ship MODIFY COLUMN chip_id VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci;