MySQL_001:中文乱码
参考文档:https://www.cnblogs.com/zhchoutai/p/7364835.html
1.1 查看mysql编码:
show variables like '%char%'
1.2 DB指定编码:
-- ----------------------------
-- 创建DB并指定编码
-- ----------------------------
CREATE DATABASE hms DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
-- ----------------------------
-- 修改DB编码
-- ----------------------------
ALTER DATABASE hms CHARACTER SET utf8;
1.3 Table指定编码
-- ----------------------------
-- 创建Table并指定编码
-- ----------------------------
DROP TABLE IF EXISTS `tb_name`;
CREATE TABLE `tb_name` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`no` varchar(64) DEFAULT NULL COMMENT '编号',
`remark` varchar(512) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1.4 改动mysql配置文件/etc/my.cnf
#增加以下三项配置:
[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8