SQL插入多语言数据 - 丢失变音符号等

CREATE DATABASE my_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE TABLE my_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    content TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
);

content = "你好，世界！"
content_utf8 = content.encode("utf-8")

import mysql.connector

cnx = mysql.connector.connect(
    user="username",
    password="password",
    host="localhost",
    database="my_database",
    charset="utf8mb4"
)

cursor = cnx.cursor()

content = "你好，世界！"
content_utf8 = content.encode("utf-8")

insert_query = "INSERT INTO my_table (content) VALUES (%s)"
cursor.execute(insert_query, (content_utf8,))

cnx.commit()
cursor.close()