create database school;
use school;
create table teacher1 (id int(3) auto_increment not null primary key,name char(10) not null,address varchar(50));
insert into teacher1 values(8,'jack','大连二中');
insert into teacher1 values(7,'mak','大连二7中');
insert into teacher1 values(6,'xia','大连二6中');
insert into teacher1 values(5,'hou','大连二5中');
insert into teacher1 values(4,'yao','大连二4中');
insert into teacher1 values(3,'jhun','大连二3中');
insert into teacher1 values(2,'lihuan','大连二2中');
insert into teacher1 values(1,'zhang','大连二1中');
insert into teacher1 values(9,'bing','大连二9中');
insert into teacher1 values(10,'jiang','大连二中');
ERROR 1300 (HY000): Invalid utf8 character string: '\xA1\xB1'
create database `中国`;
show variables like 'char%';
--------------------------+----------------
| Variable_name | Value
+--------------------------+----------------
| character_set_client | gbk
| character_set_connection | gbk
| character_set_database | latin1
| character_set_filesystem | binary
| character_set_results | gbk
| character_set_server | latin1
| character_set_system | utf8
| character_sets_dir | C:/Program File
+--------------------------+----------------
big5 | Big5 Traditional Chinese
gb2312 | GB2312 Simplified Chinese
gbk | GBK Simplified Chinese
utf8 | UTF-8 Unicode
alter database mydb character set gbk(gbk);
set character_set_client=gbk;
set character_set_connection=gbk;
set character_set_results=gbk;
set names 'utf8'
create table test (id int(3) auto_increment not null primary key,name char(10) not null,address varchar(50));
insert into test values(8,'jack','大连二中');
insert into test values(7,'mak','大连二7中');
insert into test values(6,'xia','大连二6中');
insert into test values(5,'hou','大连二5中');
insert into test values(4,'yao','大连二4中');
转载于:https://blog.51cto.com/xiahouyao123/1361069