mysql显示字符编码

-- 查看服务器默认字符集和排序规则
SHOW VARIABLES LIKE 'character_set_server';
SHOW VARIABLES LIKE 'collation_server';

-- 查看数据库字符集和排序规则
SHOW CREATE DATABASE your_database_name;

-- 查看表字符集和排序规则
SHOW CREATE TABLE your_table_name;

-- 查看列字符集和排序规则
SHOW FULL COLUMNS FROM your_table_name;

// PHP示例
$mysqli = new mysqli("host", "user", "password", "database");
$mysqli->set_charset("utf8mb4");

# Python示例
import pymysql

conn = pymysql.connect(host='host', user='user', password='password', db='database', charset='utf8mb4')

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;