mysql编码问题

--查看数据库的字符集
show variables like 'character\_set\_%';
show variables like 'collation_%';
--设置数据库字符编码
set names “uft8”
alter database payment character set uft8;
create database mydb character set uft8;
set character_set_client=uft8;
set character_set_connection=uft8;
set character_set_database=uft8;
set character_set_results=uft8;
set character_set_server=utf8;
set character_set_system=uft8;
set collation_connection=uft8;
set collation_database=utf8;
set collation_server=uft8;