注意 安装mysql时最好设置成utf8格式字符编码,安装过程中有一个界面是设置字符的,选择第三个,并从右边下拉框中选择utf8即可,这样mysql的字符集变成utf8了。
一、通过MySQL命令行查看、修改:
1. 查看字符编码:
mysql> show variables like 'character_set_%'; 或 mysql> SHOW VARIABLES LIKE 'character%'; (注意:后面的分号必须有)
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system