mysql 输入中文是?
程序员文章站
2022-03-16 22:05:35
...
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;