首页 > 其他 > 详细

存储emoji表情,修改字符集为utf8mb4

时间:2018-03-01 16:32:44      阅读:218      评论:0      收藏:0      [点我收藏+]

SHOW VARIABLES WHERE Variable_name LIKE ‘character_set_%‘ OR Variable_name LIKE ‘collation%‘;

SET character_set_client = utf8mb4;
SET character_set_connection = utf8mb4;
SET character_set_database = utf8mb4;
SET character_set_results = utf8mb4;
SET character_set_server = utf8mb4;

 

 

ALTER DATABASE 数据库名 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE tableName CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE tableName  CHANGE `content` `content` LONGTEXT CHARACTER SET utf8mb4

 

另外my.ini(此文件在tomcat安装目录和bin在同级)文件要修改这几处:

[client]
default-character-set = utf8mb4

port=3306

[mysql]
default-character-set = utf8mb4
 
[mysqld]
 
 
character-set-server = utf8mb4
 
 


# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

存储emoji表情,修改字符集为utf8mb4

原文:https://www.cnblogs.com/duanqiao123/p/8488142.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!