查看表字符集:
show variables like '%char%';
show table status from database_name like '%table_name%';show full columns from table_name;
step1, 查看数据库设置是否一致:
通过以下命令
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 | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/charsets/ |
character_set_client ,character_set_connection,character_set_database ,character_set_results,character_set_server 四个系统参数保持一致,这里用的utf8,统一设置成utf8。
字段含义:
character_set_client 客户端字符集
character_set_connection 客户端与服务器端连接采用的字符集
character_set_results SELECT查询返回数据的字符集
character_set_database 数据库采用的字符集
统一设置SET NAMES 'UTF8',
写设置mysql> SET CHARACTER SET UTF8,
读设置mysql> SET CHARACTER_SET_RESULTS=UTF8'
mysql chracter_set_server 进行修改:
方案一:修改mysql的my.ini文件中的字符集键值,(去掉my.ini配置文件的注释)
如 default-character-set = utf8
character_set_server = utf8 ;