sqlyog导入导出数据时设置编码,防乱码

  • A+
所属分类:数据分析

1.导出数据设定的编码
SET character_set_client = utf8mb4;
SET character_set_results = gb2312;
SET character_set_connection = utf8mb4;

2.导入数据设定的编码
SET character_set_client = utf8mb4;
SET character_set_results = utf8mb4;
SET character_set_connection = utf8mb4;

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: