Difference between utf8mb4 and utf8

The error er_truncated_wrong_value_for_field: incorrect string value: '\ xf0 \ x9f \ x98 \ x8b \ xf0 \ x9f... the 'for column 'post' at Row 1 error was found by Google due to the database encoding problem because the emoj expression exists in our comment data, these expressions are encoded in four bytes and one unit, while the UTF-8 encoding we usually use is encoded in the MySQL database by default in three bytes and one unit, this is the reason why an error occurs when data is stored in the MySQL database!

 

MySQL added the utf8mb4 encoding after 5.5.3. mb4 is the meaning of most bytes 4, which is specially used to be compatible with four-byte Unicode. Fortunately, utf8mb4 is the superset of utf8. You do not need to convert the encoding to utf8mb4. Of course, utf8 is enough to save space.

Theoretically, the UTF-8 format uses one to six bytes and can encode up to 31 characters. The latest UTF-8 specification uses only one to four bytes and can encode up to 21 bits, representing exactly all 17 Unicode planes.

 

 

Reference URL:

55670782

Https://developers.weixin.qq.com/community/develop/doc/000c4444fb43a0e683e621c445b000? Highline = incorrect % 2520 string % 2520 Value

Difference between utf8mb4 and utf8