设置utfmb

show variables like 'character_set_%';

 

 

show variables like 'collation_%';

 

ALTER DATABASE database CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

 

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

 

 ALTER TABLE dream_comment CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

 

 

jdbc:mysql://*******:3306/database?#useUnicode=true&noAccessToProcedureBodies=true&autoReconnect=true&rewriteBatchedStatements=TRUE