插入文本到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 pymysql

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

mysqldump -u user -p --default-character-set=utf8mb4 mydb > mydb.sql

mysql -u user -p --default-character-set=utf8mb4 mydb < mydb.sql

CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE mydb;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

import pymysql

# 连接数据库
conn = pymysql.connect(
    host='localhost',
    user='user',
    password='password',
    db='mydb',
    charset='utf8mb4'
)

# 创建游标
cursor = conn.cursor()

# 插入数据
sql = "INSERT INTO users (name, email) VALUES (%s, %s)"
data = ('张三', 'zhangsan@example.com')
cursor.execute(sql, data)

# 提交事务
conn.commit()

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