Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to solve the problem of MySql console Chinese display," the content is simple and easy to understand, clear organization, I hope to help you solve doubts, let Xiaobian lead you to study and learn "how to solve the problem of MySql console Chinese display" this article bar.

Phenomenon:

MySql server character set is set to utf8, and then insert Chinese characters in the console, the result screen shows garbled, in the console search, also garbled.

Solution:

Set the character set before inserting:

set names gbk;

Then insert:

insert into xxx values (....);

The above is "How to solve MySql console Chinese display problems" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.