mysql的char中文乱码

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 users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name CHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
""")

# 插入数据
cursor.execute("INSERT INTO users (name) VALUES (%s)", ('张三',))
conn.commit()

# 查询数据
cursor.execute("SELECT * FROM users")
result = cursor.fetchall()
for row in result:
    print(row)

cursor.close()
conn.close()