emoji is an emoticon, and is already a very popular expression on mobile phones.
Facing problems:
Inserting Emoji expressions and saving to the database gives an error:
SQLException: Incorrect string value: 'xF0x9Fx98x84' for column 'review' at row 1
UTF-8 The encoding may be two, three, or four bytes. Emoji expressions are 4 bytes, and Mysql's utf8 encoding can be up to 3 bytes, so the data cannot be inserted.
Solution:
1. Modify the character set in the data table structure to utf8mb4, but this change is relatively large and has a great impact on products that have been released online.
2. Filter it out, or replace it with UBB. This is the method I use in the project. Use reference https://github.com/newjueqi/converemojitostr
refer:
The starting point for emoji processing methods: http://blog.csdn.net/ugg/article/details/44225723
PHP-emoji conversion table: http://code.iamcal.com/php/emoji /
The above is an introduction to PHP's processing of mobile emoji expressions, including aspects of it. I hope it will be helpful to friends who are interested in PHP tutorials.