mysql创建数据库和数据库表时使用utf-8编码

1. 创建数据库默认使用utf8编码

create database oamaster character set utf8 collate utf8_general_ci;

2.创建数据库表默认使用utf8编码

create table tb_user(
id int(10) PRIMARY KEY AUTO_INCREMENT,
user_name varchar(20),
password varchar(20),
name varchar(20),
age int(10),
sex int(10),
birthday date,
created date,
updated date
)character set utf8 collate utf8_general_ci;