mysql存到数据库表中的中文乱码

-- 查看数据库字符集
SHOW CREATE DATABASE your_database_name;

-- 查看表字符集
SHOW CREATE TABLE your_table_name;

-- 查看字段字符集
SHOW FULL COLUMNS FROM your_table_name;

-- 修改数据库字符集
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", "username", "password", "database");
$mysqli->set_charset("utf8mb4");

import pymysql

conn = pymysql.connect(host='localhost', user='username', password='password', db='database', charset='utf8mb4')

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

if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

$mysqli->set_charset("utf8mb4");

$sql = "INSERT INTO your_table_name (your_column_name) VALUES (?)";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("s", $value);

$value = "你好，世界！";
$stmt->execute();

echo "Data inserted successfully!";

$stmt->close();
$mysqli->close();
?>