10 recommended courses on Emoji expressions

Emoji expressions are often encountered in our daily development, but recently I encountered a problem when inserting emoji expressions into mysql. I finally solved it by searching for relevant information, so I will share the process of solving this problem. This article mainly I will introduce to you the solution to the problem of MySQL failure to insert emoji expressions. Friends in need can refer to it. Preface I used to think that UTF-8 was a universal solution to character set problems until I encountered this problem recently. Recently, I was working on a crawler for Sina Weibo. When saving, I found that as long as I kept the emoji expression, the following exception was thrown: Incorrect string value: '\xF0\x90\x8D\x83\xF0\x90...' Well-known UTF -8 is 3 bytes, which already includes most of the fonts we see every day. But 3 bytes are far from enough to accommodate all text, so there is utf8mb4, which is a superset of utf8, accounting for 4 Bytes, backward compatible with utf8. The emoji expressions we use daily are 4

1. Solution to the problem of MySQL failure to insert emoji expressions

Introduction: Emoji expressions are often encountered in our daily development, but recently we have encountered problems when inserting emoji expressions into mysql. By searching for related The information was finally solved, so I will share the solution process. This article mainly introduces the solution to the problem of MySQL failure to insert emoji expressions. Friends who need it can refer to it.

2. An example tutorial on developing Emoji expressions on WeChat

##Introduction: emoji is an emoticon; the word meaning comes from Japanese (えもじ, e-moji, moji means character in Japanese). Emoticons are now widely used in mobile phone text messages and online chat software. Emoji emoticons are already a very popular expression used in foreign mobile phone text messages.

3. mysql saves emoji expressions (WeChat development user nickname..)

Introduction: This article mainly introduces using mysql to save emoji expressions (WeChat development user nickname..)

4. Push emoji expressions garbled characters Solution

Introduction: If the push content contains emoji expressions, the following modifications need to be made 1 mysql to Use version 5.5.3 or above (if you cannot upgrade, please use base64 to save and then transcode when pushing) 2 Modify the table and push content table fields to utf8mb4_unicode_ci encoding format (no need to change the system my.cnf, nor restart mysql ) If apnsphp is used for push, there may still be a problem that the emoji expression becomes ?: Please find the getPayload method of Message.php...

5. Push Solution to garbled emoji expressions

## Introduction: If the push content contains emoji expressions, the following modifications need to be made 1 mysql needs to use version 5.5.3 or above (if it cannot be upgraded, please save it in base64 and then transcode it when pushing) 2 Modify the table and push content table fields to utf8mb4_unicode_ci encoding format (no need to change the system my.cnf, nor Mysql needs to be restarted) If apnsphp is used for push, the problem of sending emoji expressions may still appear?: Please find the getPayload method of Message.php...

6.

javascript - Can Baidu ueditor support emoji expressions?

Introduction: Has anyone done this before? Please give me some advice. The emoji expressions sent on the client are not displayed in the background rich text file

7.

thinkphp reports an error when executing 'set names utf8mb4'

Introduction: Running environment: sae + thinkphpDB_CHARSET is utf8; (Set directly to utf8mb4 and an error will be reported. I don’t know why...) If you want to support emoji expressions, the test code is as follows public function test(){ {code ...} Error message: [SQL statement]: set names utf8mb...

8. MYSQL utf8mb4 Insert emoji garbled characters

Introduction: Regarding the problem of MYSQL utf8mb4 string set. The table structure is as follows: The following code: {code...} But after entering the database, it is a? As shown below: Looking for a solution.

9. PHP handles sending and receiving messages with Emoji expressions in WeChat Unicode character transcoding encoding

Introduction ::This article mainly introduces PHP's processing of sending and receiving Unicode character transcoding encoding for messages with Emoji expressions in WeChat. Students who are interested in PHP tutorials can refer to it.

10. PHP handles mobile emoji expressions

Introduction::This article mainly introduces PHP to handle mobile emoji expressions For emoji expressions, students who are interested in PHP tutorials can refer to it.

[Related Q&A recommendations]:

javascript - How to display emoji expressions on web pages?

php - Is there a way to save emoji expressions in the MYSQL GBK database?

javascript - How to handle the replacement of emoji expressions better

How does php call the WeChat user information interface to store the emoji expression in the nickname in mysql?

How python handles strings with emoji expressions

The above is the detailed content of 10 recommended courses on Emoji expressions. For more information, please follow other related articles on the PHP Chinese website!