按照下述修改mysql配置文件,重启生效
==================================================
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
init-connect='SET NAMES utf8'
character-set-server = utf8
==================================================
下面的方法不靠谱!!!!
关于mysql字符集问题
查看字符集
SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+-----------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /home/mysql/mysql5.7.13/share/charsets/ |
+--------------------------+-----------------------------------------+
修改character_set_server
use 数据库名;
set @@character_set_server='utf8';
--修改其他参数,如character_set_database,方法
同上
SHOW
VARIABLES
WHERE
Variable_name
LIKE
'character\_set\_%'
OR
Variable_name
LIKE
'collation%'
;
set @@character_set_client='utf8mb4';
set @@character_set_connection='utf8mb4';
set @@character_set_database='utf8mb4';
set @@character_set_results='utf8mb4';
set @@character_set_server='utf8mb4';
set @@collation_connection='utf8mb4_unicode_ci';
set @@collation_database='utf8mb4_unicode_ci';
set @@collation_server='utf8mb4_unicode_ci';
重启后失效!!!
character_set_system参数与系统字符集相关,只读。
腾讯云数据库修改某个库的默认字符集示例
ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE ...];