MariaDB设置字符编码UTF8

检查字符编码

mysql> show variables like '%char%';

使用mysql命令设置（此种方式重启数据库失效）

set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set collation_connection = utf8_general_ci;
set collation_database = utf8_general_ci;
set collation_server = utf8_general_ci;

使用show variables like ‘%char%’;查看

永久有效的配置

SET GLOBAL character_set_client     = utf8;
SET GLOBAL character_set_connection = utf8;
SET GLOBAL character_set_database   = utf8;
SET GLOBAL character_set_results    = utf8;
SET GLOBAL character_set_server     = utf8;

找到MariaDB的配置文件 data/my.ini
在[client]字段里加入

default-character-set=utf8

在[mysqld]字段里加入

character-set-server=utf8

然后保存就可以了 重启一下MySQL（也就是MariaDB）
登录数据库 输入以下命令

SHOW VARIABLES LIKE 'character%';

注意

全部设置为utf8，在插入中文数据时会出现以下报错

ERROR 1366 (22007): Incorrect string value:

解决办法就是把上面my.ini文本里的
default-character-set=utf8
character-set-server=utf8
删除即可，即部分编码变为gbk