解决MySql Command Line Client查询结果乱码问题
来源:互联网 发布:中国软件杯东软睿道 编辑:程序博客网 时间:2024/05/16 05:00
乱码问题:
数据库是MySql,存储的是中文的内容用MySql Command Line Client 查看是乱码,但是用MySql Administrator查看却显示正确
先看数据库的相关编码
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 | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |+--------------------------+---------------------------------------------------------+查看数据库表数据出现乱码,首先MySql Administrator查看却显示正确的,只是用MySql Command Line Client查看显示乱
mysql> select * from student;+----+------+------+| id | name | age |+----+------+------+| 1 | 涓? | 4 |+----+------+------+1 row in set (0.00 sec)
问题分析,这个原因主要是受客户端的连接相关编码影响,下面三项
character_set_client
character_set_connection
character_set_results
而这三项是可以通过set names utf8|set names gbk来可以设置的!另外也说明当前连接的客户端的编码情况没有影响到数据库服务器本身的编码情况。
mysql> set names gbk;Query OK, 0 rows affected (0.00 sec)mysql> show variables like 'character_set_%';+--------------------------+---------------------------------------------------------+| Variable_name | Value |+--------------------------+---------------------------------------------------------+| character_set_client | gbk || character_set_connection | gbk || character_set_database | utf8 || character_set_filesystem | binary || character_set_results | gbk || character_set_server | utf8 || character_set_system | utf8 || character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |+--------------------------+---------------------------------------------------------+8 rows in set (0.00 sec)mysql> select * from student;+----+------+------+| id | name | age |+----+------+------+| 1 | 上 | 4 |+----+------+------+
- 解决MySql Command Line Client查询结果乱码问题
- 解决MySql Command Line Client查询结果乱码问题
- 解决MySql Command Line Client查询结果乱码问题
- 解决MySql Command Line Client查询结果乱码问题
- 解决MySql Command Line Client查询结果乱码问题
- mysql (MySql Command Line Client) 乱码问题 补充
- MySQL Command Line Client 的中文乱码问题
- MySql Command Line Client 出现乱码
- MySQL Command Line Client一闪而过的问题
- mysql command line client的中文问题
- MySQL Command Line Client
- MySQL Command Line Client
- mysql (MySql Command Line Client) 保存数据后乱码
- mysql command line client 打不开(闪一下消失)及解决
- mysql command line client语法
- mysql 查询结果 导出 excel格式并解决乱码问题
- 在MySQL command line client 中使用 mysqldump问题
- 解决mysql查询结果中文显示乱码
- zj01
- wxPython实现窗口在任务栏中闪烁
- 一个毕业6年的程序员工作经历和成长感悟(中)
- Android应用如何做屏幕适配
- 可视化排序程序
- 解决MySql Command Line Client查询结果乱码问题
- 杨洋(161)-计算机是如何工作的(实验一)
- debian wheezy 修改默认配置
- Roman To Integer
- C#调用C++DLL中的回调函数(异步的情况,DLL中会在事件触发时调用函数)
- 黑马程序员-JAVASE入门(组成部分1变量,函数等)
- unity3D 输出FPS
- 三星I9100如何鉴别翻新机
- [2013-05-15]安装centos6.3-x86_64