关于mysql字符集的修改

按照下述修改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 ...];