mysql查询结果乱码
2024-09-27 01:13:40
1.查询数据库结果乱码
mysql> select doctitle,docpuburl from wcmdocument order by docpubtime desc limit 0,3;
+-----------+-------------------------------------------------------------+
| doctitle | docpuburl |
+-----------+-------------------------------------------------------------+
| 2016-???? | http://xxx/case_usa/case_uk_bk/1075572.shtml |
| 2016-???? | http://xxx/case_uk_bk/1075570.shtml |
| 444??333 | http://xxx/test/blog/1333090.shtml |
+-----------+-------------------------------------------------------------+
3 rows in set (0.00 sec)
2.通过show variables like 'character_set_%';命令查询发现字符集不是utf-8
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql5.6.39/share/charsets/ |
+--------------------------+----------------------------------------+
8 rows in set (0.00 sec)
3.修改字符集为utf-8
mysql> set character_set_client=utf8;
Query OK, 0 rows affected (0.00 sec) mysql>
mysql> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec) mysql> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec) mysql> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)
4.查询修改结果是否生效;
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/local/mysql5.6.39/share/charsets/ |
+--------------------------+----------------------------------------+
8 rows in set (0.00 sec)
5.再次查询,解决乱码
mysql> select doctitle,docpuburl from wcmdocument order by docpubtime desc limit 0,3;
+-------------------+-------------------------------------------------------------+
| doctitle | docpuburl |
+-------------------+-------------------------------------------------------------+
| 2016-xx数据 | http://xxx/case_usa/case_uk_bk/1075572.shtml |
| 2016-xx数据 | http://xxx/case_uk_bk/1075570.shtml |
| 2016-xx数据 | http://xxx/test/blog/1333090.shtml |
+-------------------+-------------------------------------------------------------+
3 rows in set (0.00 sec)
最新文章
- 【转】iOS UIApplication详解
- C#程序员的春天之从零开始学习unity3D游戏开发入门教程二（创建项目及基本面板介绍）
- java 字节数组转int
- winedt设置自动显示行号[latex]
- HTTP请求响应报文&&相关状态码&&GET_POST请求方法 总结
- 计算机中的颜色XIV——快速变换颜色的V分量
- 记一个有想法却没能力实现的硬件产品——mp3校时闹钟
- Java RMI 远程方法调用
- 什么是优先级队列（priority queue）？
- linux学习方法之六
- JavaIO流程--创建文件和目录的实例
- C++中Map常见用法以及按照value排序
- iOS之文件解析
- SpringBoot系列: Json的序列化和反序列化
- THINKPHP5近期暴露的漏洞
- resize2fs
- 【转】深入浅出JMS（一）--JMS基本概念
- 接收Android数据 递归显示表格数据
- C# 抓取并导出网页里面所有超链接方法
- MongoDB 日记参数