最近总是被mysql的乱码困扰,虽然解决了乱码,但是还不不太清楚,各位帮我看看,下面显示的字符集两类,每个都是代表什么意思?在干什么的时候会用到?为什么会出现乱码?我一般是和php连接的,连接php的时候有时候也会出现乱码?
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| 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 | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| 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 | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)
解决方案 »
- mysql 存储过程 查询
- MYSQL如何做增量备份后还原出错,请高手指点
- 简单的replace后,再次调用失败?什么原因?
- myisam联合主键大批量插入效率问题请教
- Mysql 无法安装【求救】~!~!~
- mysql中 不同数据库间 不同表结构的表之间的数据传输问题
- 无头绪--跨表区域统计查询
- 帮我优化一下SQL语句!谢谢(mysql)
- 我的win2000下的php+mysql顯示以下錯誤!!
- 请问怎样在网页中显示放在MYSQL数据库中的文章呢?
- mysql实用sqlyog community dump出的sql文件中汉字显示为乱码
- MySQL建立数据库时的字段的Collation 属性 是指什么?
MySQL 中文显示乱码