Home>Article>Database> How to solve the problem of Chinese garbled characters in mysql 5.6

How to solve the problem of Chinese garbled characters in mysql 5.6

藏色散人
藏色散人 Original
2021-12-21 15:16:49 2751browse

Mysql5.6 Chinese garbled solution: 1. Find my.ini in the MySQL installation directory; 2. Set "default-character-set=utf8" and "character_set_server=utf8"; 3. Restart MYSQL service is enough.

How to solve the problem of Chinese garbled characters in mysql 5.6

The operating environment of this article: Windows 7 system, mysql version 5.6, Dell G3 computer.

How to solve the problem of Chinese garbled characters in mysql 5.6?

About the problem of Chinese garbled characters in MySQL 5.6 (especially the gbk encoding of windows)

一般MySQL 数据库乱码由以下几种情况造成(按照顺序): 1. 创建数据库的时候没设置编码,解决办法: 就是在创建数据库的时候设置编码, 例如: CREATE DATABASE `mydb` CHARACTER SET utf8 COLLATE utf8_general_ci; 2. 创建数据表的时候没设置数据库引擎编码, 解决办法:CREATE TABLE `tb_album` (`id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`))ENGINE=InnoDB DEFAULT CHARSET=utf8; 3.MySQL导入.sql文件的时候,由于编码问题,导致中文乱码,首先进入数据库 mysql -u root -p 然后输入密码进入, 然后输入命令查看编码show variables like 'char%';

你会发现很多编码默认都是gbk,而且character_set_server(这个就是导入.sql文件的时候导致乱码的原因)的编码默认是latin1, 其他的都可以在mysql控制台通过命令 set xxx = utf8; 修改编码(永久修改), 唯独character_set_server不行,退出之后再登录还是latin1,

解决办法:找到MySQL安装目录下的my.ini,设置default-character-set=utf8 和 character_set_server=utf8 如果你的MySQL是免安装版,那么是没有my.ini的,安装目录下只有my-default.ini文件,而且打开也没有character-set-server, 先把my-default.ini拷贝一份,并重命名为my.ini,这样该目录下就有了my.ini和my-default.ini两个ini文件 然后打开my.ini加上以下三行代码 [client] default-character-set=utf8 /[mysqld]/ character-set-server=utf8

The specific location is as follows:

Then restart the MYSQL service and find that character-set-server is no longer latin1:

如果你的MySQL是安装版本,那就找到my.ini,设置default-character-set=utf8 和 character-set-server=utf8,重启MySQL服务即可。

Recommended learning: "mysql video tutorial

The above is the detailed content of How to solve the problem of Chinese garbled characters in mysql 5.6. 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