???????show variables like 'character_set%%';??????
???????mysql?????????????????????
????1.?????????????my.ini(windows??)??/etc/my.cnf(linux??)
??????????????????
????[mysqld]
????character_server_set=utf8
????[mysql]
????default-character-set=utf8
????[mysql.server]
????default-character-set=utf8
????[mysql_safe]
????default-character-set=utf8
????[client]
????default-character-set=utf8
????2.?????????????????
????create database test character set utf8;
????3.??????????????
????create table test(id int primary key)DEFAULT charset=utf8;
????4.???????????
????alter database test character set utf8;
????5.??????????
????alter table test character set utf8;
????6.?????α???
????alter table test modify col_name varchar(50) CHARACTER SET utf8;