作者:儒雅的天麟 | 来源:互联网 | 2023-02-12 11:56
AfterreadingallthetopicsaboutemojionSOImboundedtoaskforsomehelp.Questionseemstob
After reading all the topics about emoji on SO I'm bounded to ask for some help. Question seems to be almost the same: I got an iPhone App sending via PHP emoji to MySQL DB, I can see some symbol on records, as example "umbrella" and "cloud" but other not (angry face, smiling face, and other).
在阅读了有关表情符号的所有主题之后,我有必要寻求帮助。问题似乎几乎相同:我有一个iPhone应用程序通过PHP表情符号发送到MySQL数据库,我可以看到记录上的一些符号,例如“伞”和“云”,但其他没有(愤怒的脸,笑脸,和其他)。
Why some yes and other not?
为什么有些是和其他没有?
- MySQL Collation: utf8mb_unicode_ci
MySQL排序规则:utf8mb_unicode_ci
- Table collation: utf8mb_unicode_ci
表排序规则:utf8mb_unicode_ci
- Field, varchar, collation: utf8mb_unicode_ci
Field,varchar,collation:utf8mb_unicode_ci
PHP setup:
mysql_query("SET CHARACTER SET utf8mb4");
mysql_query("SET NAMES utf8mb4");
The symbols not showed inside the record are shown as question mark "?"
记录中未显示的符号显示为问号“?”
1 个解决方案