`
baalwolf
  • 浏览: 351847 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

设置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

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics