a)查看数据库的编码:show create database databaseName; b)修改数据库编码: alter database databaseName default character set utf8 collate utf8_general_ci;
同时,你改变了编码只是一个数据库的,我们希望改变所有的,上代码
show variables like '%char%';#显示你数据库字符集列表
set character_set_client=utf8;
set character_set_connection=utf8;
set character_set_database=utf8;
set character_set_results=utf8;
set character_set_server=utf8;
set character_set_system=utf8;
set collation_connection=utf8;
set collation_database=utf8;
set collation_server=utf8;
上面代码分行写,分别运行,不要管警告
修改数据库字符集: ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE …]; 如: ALTER database test CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
修改表的默认字符集: ALTER TABLE tbl_name DEFAULT CHARACTER SET character_name [COLLATE…]; 如:ALTER TABLE logtest DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
修改字段的字符集: ALTER TABLE tbl_name CHANGE c_name c_name CHARACTER SET character_name [COLLATE …]; 如:ALTER TABLE logtest CHANGE title title VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci;