第一种方法: 只需要再建表的后面加上
ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
例如:
create table users(
uid int primary KEY AUTO_INCREMENT,
uname VARCHAR(20) not null,
uage INT NOT NULL
)ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
**第二种方法:**用设计表 将需要的字段更改字符集,以及排序规则。