The problem of adding Chinese characters garbled in MySQL is not recognized

The default character set in MySQL is UTF-8, and when you add Kanji in command-line mode, you may get an error or warning, and the results will be incorrect.

In most cases, the PHP note seems to be a command to solve ... Simply write a blog.

Command line mode, enter: Show avariables like '%char% ';

The fuzzy query results can be seen in the MySQL character set. The default is UTF-8,

Input: Set names GBK;

Set CHARACTER_SET_CLIENT=GBK;

This type of Chinese is OK ~

The problem of adding Chinese characters garbled in MySQL is not recognized