1、MySQL创建数据库(maoyandb)以及设置库编码(utf-8);
CREATE DATABASE maoyandb CHARACTER SET utf8 COLLATE utf8_general_ci;(或者:create database maoyandb charset utf8;)
2、创建表“maoyantab”,表中有三个字段,并指定表的键key为name:
name varchar(100)
star varchar(500)
time varchar(100)
命令: create table maoyantab(name varchar(100) not null,star varchar(500),time varchar(100),primary key(name));
3、maoyandb下查看数据库编码类型:show variables like 'character\_set\_%';
4、修改编码类型为"utf8":(一个个值修改)
set @@character_set_client='utf8';
5、插入一行记录(即可插入中文数据),如图: