mariadb utf8mb4导数据中文防止乱码需要设置编码

查看数据用:
SET character_set_client = utf8mb4;
SET character_set_results = utf8mb4;
SET character_set_connection = utf8mb4;

export!!导出数据用:
SET character_set_client = utf8mb4;
SET character_set_results = gb2312;
SET character_set_connection = utf8mb4;
import!!导入数据用:
SET character_set_client = utf8mb4;
SET character_set_results = utf8mb4;
SET character_set_connection = utf8mb4;

本文作者: GavinDong

版权属于: GavinDong博客

文章链接: https://gavindong.com/340.html

如果使用过程中遇到问题,可 **点击此处** 交流沟通。

版权所有,转载时必须以链接形式注明作者和原始出处及本声明。

(0)

发表回复

登录后才能评论