Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > php教程 > php手册 > 让ThinkPHP支持Emoji , 并能存入Mysql

让ThinkPHP支持Emoji , 并能存入Mysql

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-07 11:39:30
Original
1226 people have browsed it

Thinkphp默认的utf8不支持Emoji，因为Emoji是unicode编码，每个Emoji占4个字节，只要把数据表和列的编码都改为utf8mb4即可
网上找了一堆文章都没写清楚。

Thinkphp默认的utf8不支持Emoji，因为Emoji是unicode编码，每个Emoji占4个字节，按照如下方法做肯定可以用。

1、确保mysql版本大于5.3.3(支持utf8mb4)
2、把表字符集改为utf8mb4, 排列顺序为utf8mb4_general_ci
3、把字段字符集改为utf8mb4, 排列顺序为utf8mb4_general_ci

utf8mb4是utf8的延伸并向下兼容，大可放心用，不过记得备份

有部分emoji还是显示为问号，如有更好的方法请指教。

AD：真正免费，域名+虚机+企业邮箱=0元

Related labels：
thinkphp代码，代码示例，代码参考，php短信，数据库备份代码，令牌验证，去除代码中的空白和注释thinkphp
source：php.cn
Previous article：原生JS写的幻灯片 Next article：Think3.1.3运行在PHP5.5+环境下的问题解决
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Team collaboration - What should I do if someone needs the feature I wrote as a dependency in git flow?
From 1970-01-01 08:00:00
0
0
0
Objective-c - Constraints for iOS a warning issue
From 1970-01-01 08:00:00
0
0
0
Confusion about using gitlab's fork&pull request mode within the team
From 1970-01-01 08:00:00
0
0
0
Objective-c - In iOS development, Instagram cannot be authorized after logging in. Instagram does not jump back to the application. How to get the callback address?
From 1970-01-01 08:00:00
0
0
0
Version Control - About the use of SVN and GIT in company projects?
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template