Summary of solutions to Chinese garbled characters in mysql database

When operating the mysql database, if garbled characters appear, it is a very troublesome thing. The reasons why MySQL will have Chinese garbled characters are nothing more than the following points: 1. The server itself has a setting problem, for example, it is still stuck at latin1; 2. The language setting problem of the table (including character and collation); 3. The client program (such as php) connection language setting problem. Therefore, it is generally strongly recommended to use utf8! Because utf8 is compatible with all characters in the world! Below we will summarize the solutions to the Chinese garbled problem in mysql database and show it to friends for reference.

mysql database Chinese garbled code

##1.

Detailed explanation of the solution to the problem of Chinese garbled characters in Mysql5.7

When using mysql5.7, you will find that garbled characters will appear after writing Chinese to the database through the web end, but when operating SQL directly in the database After the statement is inserted into the data, the Chinese text is displayed normally

1) Open the mysql console and enter the command show variables like 'character%';

2) Modify the my.ini file

3) After restarting, use the command in the first step to view

4) Enter the command: set names utf8;

2.

Detailed explanation of the solution to the Chinese garbled database MySQL (picture and text)

MySQL is a very commonly used data database in our projects. But because we need to save Chinese characters in the database, we often encounter database garbled characters. Let’s introduce how to completely solve the problem of Chinese garbled characters in the database. Many answers on the Internet directly set the character encoding of MySQL at the session level. This is a temporary solution rather than a permanent solution. We still need to solve this problem from the source. That is to modify the default configuration file of mysql and change its character set to UTF8 that can use Chinese characters.

3.

Quick solution for reading MYSQL Chinese garbled characters with PHP

The Mysql used by foreign hosts in the past was the 4.x series, and it felt better, no matter what There is no garbled code in GBK and UTF-8. Unexpectedly, the MySQL version of the new host is version 5.0. After importing the data, when I read it with Php, it was full of question marks and garbled characters. I remember that I once had the experience of garbled characters when switching. The reason must be the difference between Mysql versions.

4.

Solution to Chinese garbled Chinese garbled data read by PHP from mssql json##PHP and web pages use UTF-8 encoding, the database is sql server2008, and the default encoding (936 , that is, GBK encoding),

When reading database data, use the json_encode() that comes with PHP to return to the front end, and the result will not be displayed in Chinese.

If you want to insert Chinese into sql server 2008 normally, you also need to add a code: $query = iconv("utf-8", "gbk//ignore", $query);/ /In order to solve the Chinese garbled code problem

5.

mysql Chinese garbled code solution collection

First of all, you must specify your upgraded database and table and field character set, generally For example, we use gb2312 or utf8. If you do not use multiple encodings at the same time, you only need to specify the database. You can add the corresponding character set to the SQL statement when building the database, and you can also modify it in phpMyAdmin.

6.

The perfect solution to the Mysql Chinese garbled problem

If the website has been running for a long time and has a lot of old data, and the Simplified Chinese settings cannot be changed, then It is recommended to set the encoding of the page to GBK. The difference between GBK and GB2312 is that GBK can display more characters than GB2312. If you want to display traditional characters in simplified code, you can only use GBK.

Related Questions and Answers1.

The problem of Chinese garbled characters in Mysql under Mac system

2 .

How to solve the Chinese garbled data when rendering the data queried by mysql? 3.

How to solve the Chinese garbled mysql under window? ?

[Related recommendations]

1. PHP Chinese website free video tutorial:

"Six Days to Take You to Play with MySQL Video Tutorial"

2. Related articles on php Chinese website:

"MySQL 5.1 Reference Manual"

The above is the detailed content of Summary of solutions to Chinese garbled characters in mysql database. For more information, please follow other related articles on the PHP Chinese website!