Get the App
SLTechnology News&Howtos  ›  Development  › 

How to solve the problem of Chinese garbled code when mysql writes data

Shulou Source: shulou.com Published: 2022-06-03 14:10:15 11月14日 Update

This article mainly explains "how to solve the problem of Chinese garbled code when mysql writes data". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to solve the problem of Chinese garbled code when mysql writes data".

The question leads to:

Write data from another system to the mysql database and find that Chinese has become?

The solution is as follows:

First check the database settings. The corresponding character set of server is latinl.

Adjust mysql parameter configuration, configuration file directory / etc/mysql/mysql.conf.d/

Add a line: character-set-server = utf8

Then restart the mysql service, check the server parameter configuration again, and rewrite Chinese is normal.

Thank you for your reading, the above is the content of "how to solve the problem of Chinese garbled code when mysql writes data". After the study of this article, I believe you have a deeper understanding of how to solve the problem of Chinese garbled code when mysql writes data, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Tags: Data problem garbled time learning configuration content parameters database Chinese service check line again character set that is ideas situations files Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Linux Xiaomi Shulou Information Huawei Shulou Tech Info