PHP handles mobile emoji emoticons

Emoji is the emoji, in the mobile phone is already very popular use of an expression.

Facing the problem:

Insert emoji expression, save to database times wrong:

Sqlexception:incorrect string value: ' \xf0\x9f\x98\x84 ' for column ' review ' at row 1

The UTF-8 encoding can be two, three, and four bytes. The emoji expression is 4 bytes, while MySQL UTF8 encodes up to 3 bytes, so data cannot be plugged in.

Solution:

1, modify the data table structure of the character set is UTF8MB4, but this change is relatively large, for the released online products have a great impact.

2, filter it out, or use UBB instead, this is my method used in the project, using the reference https://github.com/newjueqi/converemojitostr

Refer

Emoji treatment way big bottom: http://blog.csdn.net/ugg/article/details/44225723

Php-emoji Conversion Table: http://code.iamcal.com/php/emoji/

The above describes the PHP processing mobile emoji expression, including the aspects of the content, I hope that the PHP tutorial interested in a friend helpful.

