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;

-- 在连接字符串中指定字符集
jdbc:mysql://localhost:3306/your_database_name?useUnicode=yes&characterEncoding=UTF-8

# 示例代码：确保数据编码正确
import pymysql

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

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

# 插入数据
sql = "INSERT INTO your_table_name (your_column_name) VALUES (%s)"
data = ('你好',)
cursor.execute(sql, data)

# 提交事务
conn.commit()

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