create table t_emp(
id bigint primary key auto_increment,
name varchar(50) unique.
salary double,
age int
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
--------------------------------------------------------------------------------
建表时加上这句ENGINE=InnoDB DEFAULT CHARSET=utf8;
-----------------------------------------------------------------------------------
创建数据库时
create database 数据库名
default character set utf8;
--------------------------------------------------------------------------------
其他设置utf8的方法网上到处都是。