What to do if mysql emoji is garbled

Solution to mysql emoji garbled code: 1. Check the mysql table encoding through the "show create table test ENGINE=InnoDB DEFAULT CHARSET=utf8mb4" command; 2. Set the reading encoding to "through "set names utf8mb4;" utf8mb4" is enough.

The operating environment of this tutorial: Windows 10 system, MySQL version 5.7, Dell G3 computer.

What should I do if mysql emoji is garbled?

mysql emoji garbled code

Background

You need to export a batch of data with emoji expressions from mysql directly through mysql -f 3b4be98fece41d5958f1e4e9fde66768 result.csv method, the result is that the emoji expression is garbled, start to solve it!

Ideas

First think about several possibilities of garbled codes and check them one by one.

• Storage problem

• Reading problem

• Encoding causes display problem

Solution

Check the mysql table encoding

show create table test
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

It is found that there is no problem with the encoding, the encoding is utf8mb4, and when viewing the data, it is found that only some emoji If there is a problem, you can determine that there is no problem with the storage.

utf8mb4 is a superset of utf8

Look at the reading part again and set the reading encoding to utf8mb4

set names utf8mb4;

Select the query again, no more Coding problem, problem solved.

Recommended learning: "MySQL Video Tutorial"

The above is the detailed content of What to do if mysql emoji is garbled. For more information, please follow other related articles on the PHP Chinese website!