Home >Database >Mysql Tutorial >How to deal with Japanese garbled characters in mysql

How to deal with Japanese garbled characters in mysql

藏色散人
藏色散人Original
2023-02-15 10:29:412484browse

Mysql Japanese garbled solution: 1. When creating a table in the database, choose to sort it into "utf8_general_ci"; 2. When accessing the database in PHP, add the "mysql_query("SET NAMES UTF8");" statement That’s it.

How to deal with Japanese garbled characters in mysql

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

What should I do if mysql has Japanese garbled characters?

mysql Japanese field garbled problem

1 When creating the database table, choose to sort it into

utf8_general_ci

2 When accessing the database with php, add

mysql_query("SET NAMES UTF8");

Related expansion:

After logging in to MySQL, enter the following command to query the database code,

show variables like "char%";

You can get the following query results,

How to deal with Japanese garbled characters in mysql

The information contained in the query results is as follows,

①character_set_client: utf8, which means that the MySQL client uses utf8 encoding, that is: for the SQL request content that the MySQL client will send to the MySQL server, the client will use UTF8 character set encoding rules are used to encode and send.

PS: Usually, when performing SQL queries in the command line window (CMD), if the result set contains Chinese characters, garbled characters will be displayed. This is because CMD, as the MySQL client, adopts the GBK encoding format by default at this time. , and the MySQL server sends data in utf8 encoding format, resulting in garbled characters.

②character_set_connection: utf8, indicating that the utf8 encoding format is used when connecting to the MySQL database;

③character_set_database: utf8, indicating that the utf8 encoding format is used by default when creating the MySQL database;

④character_set_results :utf8, indicates the encoding format used when the database returns query results to the client;

⑤character_set_server: utf8, indicates the default encoding format used when the MySQL server is installed, and artificial modification is not recommended;

⑥character_set_system: utf8, which represents the encoding format used by the database system. It is the encoding format used when storing metadata and does not need to be set;

⑦character_set_dir: Points to the directory location where the character set is installed.

Among them, the three system variables will not affect the problem of garbled characters, including: character_set_filesystem, character_set_system, character_set_dir. You only need to pay attention to whether the other variables meet the requirements.

How to deal with Japanese garbled characters in mysql

Recommended study: "MySQL Video Tutorial"

The above is the detailed content of How to deal with Japanese garbled characters in mysql. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn