mysql 写入乱码

-- 设置数据库字符集
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 设置表字符集
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 设置列字符集
ALTER TABLE your_table_name MODIFY your_column_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

$mysqli = new mysqli("localhost", "user", "password", "database");
$mysqli->set_charset("utf8mb4");

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

<?php
$mysqli = new mysqli("localhost", "user", "password", "database");

// 设置连接字符集
$mysqli->set_charset("utf8mb4");

// 插入数据
$sql = "INSERT INTO your_table_name (your_column_name) VALUES ('你的数据')";
$mysqli->query($sql);

$mysqli->close();
?>