mysql数据库不能保存中文

-- 设置数据库字符集
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=yes&characterEncoding=UTF-8

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

mysqldump -u username -p --default-character-set=utf8mb4 your_database_name > backup.sql

mysql -u username -p --default-character-set=utf8mb4 your_database_name < backup.sql