mysql 修改 character_set_database_如何对MySQL的字符集character_set和校验集Collation设置和修改解决乱码等问题？...

--查看mysql当前编码方式:

show variables like 'character%';

--修改编码方式:

set names utf8;

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;

--查库编码:

use 库名bai

show variables like 'character_set_database';

--修改:

alter database 库名 CHARACTER SET utf8;

--查表编码:

show create table 表名;

--修改:

alter table 表名 convert to character set utf8;

--查字段编码:

show 字段名 columns from 表名;

--修改:

ALTER TABLE '表名' CHANGE `字段名` `字段名` VARCHAR(36) CHARACTER SET utf8 NOT NULL;

--但是以上都很麻烦,建议楼主在建表时定义该表的编码方式

--如一个建表语句：

create table program(

sid int unsigned not null primary key auto_increment,

name char(20) not null,

age tinyint,

gender enum('M','F')

)engine=innodb default charset=utf8;