如何查看mysql数据库字符集编码

-- 查看当前数据库的字符集编码
SHOW VARIABLES LIKE 'character_set_database';

-- 查看当前数据库的排序规则
SHOW VARIABLES LIKE 'collation_database';

-- 查看所有表的字符集编码
SELECT TABLE_NAME, TABLE_COLLATION FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'your_database_name';

-- 查看特定表的字符集编码
SHOW CREATE TABLE your_table_name;

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;

jdbc:mysql://localhost:3306/your_database_name?useUnicode=true&characterEncoding=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;