简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

phpmyadmin中文显示数字+小写字母，和普遍的乱码不通

WBOY
Release： 2016-06-23 13:51:01
Original
1159 people have browsed it

http://zhidao.baidu.com/link?url=qn78e6uO1HxBwuE8If8JZhRjbQBfr2vWefT-ye4rEJfy4rTs2BoXbqMbyGXnqPpDMUdrdkke0-UM-1ggg0xPM_
百度里只有1个帖子和我的情况一样， 但是题主没有给出解决办法。
希望大神可以给我指导，谢了


回复讨论(解决方案)

贴出你的数据

     title中应该是中文，但是显示为数字+小写字母的乱码，如果点击编辑和从其他终端查看本数据库，看到的就不是乱码，如图。

那是十六进制内码，还真没见过这种情况
看看你的表结构

和phpmyadmin有关吧，既然终端查询正常就别管他了呗。

那是十六进制内码，还真没见过这种情况
看看你的表结构




这是数据库结构和表结构

这就对了，你的连接校对（collate）是 utf8_bin 
所以也就是这样了

这就对了，你的连接校对（collate）是 utf8_bin 
所以也就是这样了


这个数据表都是从朋友那里导出，然后倒入到我的数据库中的，在朋友那里显示就正常的。而且我试了，新建个数据库，把连接校对改成utf8_bin，也是不行

xuzuning 的回答已解决我的问题，在此谢了！

Related labels：
Chinese Garbled characters Lower case letters number show
source：php.cn
Previous article：帮我看看用什么函数可以实行下面的结果 Next article：linux安装php与memcache过程记录
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！