mysql将表的字符编码转换成utf-8
alter table tb_anniversary convert to character set utf8;
查看数据库中某个表的编码方式:
show create table table_name ;
查看mysql的编码方式:
show variables like 'char_%';
查看数据库支持的字符集
show charset;
最好保证客户端数据库等编码方式统一,防止出错
mysql> show variables like 'char%';
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | F:\mysql-5.6.17-winx64\share\charsets\ |
+--------------------------+----------------------------------------+
8 rows in set (0.00 sec)
也可以不修改my.ini文件
当客户端的编码方式为gbk时,可以再建表的时候默认表的编码方式为gbk即可。
create table ....(
....
.....)default charset=gbk;