thinkPHP5.0字符集修改为utf8mb4

Q:为什么要用utf8mb4
A:utf8mb4可以直接保存emoji字符

MySQL修改字符集

// 数据表编码改为utf8mb4
function to_utf8mb4()
{$database = config("database.database");$sql = "ALTER DATABASE `{$database}` CHARACTER SET `utf8mb4` COLLATE `utf8mb4_general_ci`;"; //数据库// Db::execute($sql);echo $sql;$lists = Db::getTables();foreach ($lists as $key => &$value) {Db::execute("ALTER TABLE `{$value}` CONVERT TO CHARACTER SET `utf8mb4` COLLATE `utf8mb4_general_ci`;"); //数据表$fields = Db::getFields($value);foreach ($fields as $key1 => &$value1) {if (mb_strpos(strtolower($value1["type"]), "char") !== false) {Db::execute("ALTER TABLE `{$value}` CHANGE `{$value1["name"]}` `{$value1["name"]}` {$value1["type"]} CHARACTER SET `utf8mb4` COLLATE `utf8mb4_general_ci` DEFAULT '{$value1["default"]}';"); //字段}}}
}

thinkPHP5.0框架

// 数据库编码默认采用utf8
'charset' => 'utf8',

新的

// 数据库编码默认采用utf8
'charset' => 'utf8mb4',

修改之后可以直接存储emoji

普通的utf8字符

emoji

参考文章
https://blog.csdn.net/qq_50573146/article/details/125177260