MySQL-编码字符集

1，查看数据库使用的编码格式

  show variables like "%colla%";

  show variables like "%char%";

2，修改数据库编码为utf8

  set character_set_client = 'utf8';

  set character_set_connection = 'utf8';

  set character_set_results = 'utf8';

3，修改具体某数据库编码

  alter database ‘db_name’ default character set utf8 collate utf_general_ci;

4，修改具体某个数据表编码

  alter table ‘tb_name’ default character set utf8 collate utf_general_ci;