python插入mysql数据库中文乱码

CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE TABLE mytable (
    id INT PRIMARY KEY,
    name VARCHAR(255)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

import mysql.connector

config = {
    'user': 'your_user',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database',
    'charset': 'utf8mb4'
}

conn = mysql.connector.connect(**config)
cursor = conn.cursor()

# 插入数据
sql = "INSERT INTO mytable (name) VALUES (%s)"
value = ("中文",)
cursor.execute(sql, value)
conn.commit()

# 确保字符串是UTF-8编码
name = "中文".encode('utf-8').decode('utf-8')

import mysql.connector

# 数据库连接配置
config = {
    'user': 'your_user',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database',
    'charset': 'utf8mb4'
}

# 连接数据库
conn = mysql.connector.connect(**config)
cursor = conn.cursor()

# 创建表（如果表不存在）
cursor.execute("""
CREATE TABLE IF NOT EXISTS mytable (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
""")

# 插入数据
sql = "INSERT INTO mytable (name) VALUES (%s)"
value = ("中文",)
cursor.execute(sql, value)
conn.commit()

# 关闭连接
cursor.close()
conn.close()