代码: 全选
SHOW CREATE DATABASE database_name;
代码: 全选
SHOW VARIABLES LIKE 'character_set_client';
代码: 全选
MariaDB [nextcloud]> SHOW VARIABLES LIKE 'character_set_client';
+----------------------+--------+
| Variable_name | Value |
+----------------------+--------+
| character_set_client | latin1 |
+----------------------+--------+
1 row in set (0.001 sec)
/etc/mysql/mariadb.conf.d/50-client.cnf
,在 [client]
字段下添加
代码: 全选
default-character-set=utf8mb4
重新进mariadb shell,可以看到修改生效了
代码: 全选
MariaDB [(none)]> SHOW VARIABLES LIKE 'character_set_client';
+----------------------+---------+
| Variable_name | Value |
+----------------------+---------+
| character_set_client | utf8mb4 |
+----------------------+---------+
1 row in set (0.001 sec)