mysql 输入中文是？

mysql 输入中文是？？？ 先查看所有的编码 show variables like 'char%'; 所有的latin改成utf-8 set character_set_database= 'utf8'; set character_set_server= 'utf8'; 就好了 create database dbclass default character set utf8 collate utf8_general_c

mysql 输入中文是？？？

先查看所有的编码 show variables like 'char%';

所有的latin改成utf-8

set character_set_database= 'utf8';
set character_set_server= 'utf8';

就好了

create database dbclass default character set utf8 collate utf8_general_ci;

CREATE TABLE S
(
SNO VARCHAR(7),
SNAME VARCHAR(20) NOT NULL,
STATUS VARCHAR(20) ,
CITY VARCHAR(20),
CONSTRAINT PK_S PRIMARY KEY(SNO)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;