先查看所有的编码  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;