mysql 设置字符集utf8

CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE mytable (
    id INT PRIMARY KEY,
    name VARCHAR(100)
) CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE mytable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

import mysql.connector

config = {
    'user': 'your_user',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database',
    'charset': 'utf8'
}

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

SET NAMES utf8;

ALTER DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE mytable CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;