且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在my.cnf中将MySQL默认字符集更改为UTF-8?

更新时间:2022-12-05 15:50:04

要将默认值设置为UTF-8,您要将以下内容添加到my.cnf

To set the default to UTF-8, you want to add the following to my.cnf

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

如果你想改变一个现有的数据库的字符集,让我知道...你的问题没有直接指定,所以我不知道这是你想做的。

If you want to change the character set for an existing DB, let me know... your question didn't specify it directly so I am not sure if that's what you want to do.