ALTER DATABASE `databasename` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE `tableName` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE `tableName` CHANGE `dd` `dd` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
create table()ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='哈喽啦'
show variables like 'collation_%';
SHOW VARIABLES LIKE 'character%';
SET character_set_client = utf8 ;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set character_set_system = utf8;
set collation_connection='utf8_general_ci';set collation_database='utf8_general_ci';
set collation_server='utf8_general_ci'; Gavin