文件写入mysql乱码

import mysql.connector

config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database',
    'charset': 'utf8mb4'  # 设置连接编码为UTF-8
}

try:
    conn = mysql.connector.connect(**config)
    cursor = conn.cursor()
    # 执行SQL语句
    cursor.execute("INSERT INTO your_table (column_name) VALUES (%s)", ('你的文本',))
    conn.commit()
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    cursor.close()
    conn.close()

ALTER TABLE your_table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

# 查看当前编码
locale

# 修改默认编码（以Ubuntu为例）
sudo locale-gen "en_US.UTF-8"
sudo update-locale LANG=en_US.UTF-8