mysql插入繁体字

-- 创建数据库并设置字符集
CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 创建表并设置字符集
CREATE TABLE mytable (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
);

-- 插入繁体字数据
INSERT INTO mytable (name) VALUES ('繁體字測試');

-- 查询数据
SELECT * FROM mytable;

import mysql.connector

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

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

# 执行查询
query = "SELECT * FROM mytable"
cursor.execute(query)

for row in cursor:
    print(row)

cursor.close()
cnx.close()