phpmyadmin中文显示数字+小写字母，和普遍的乱码不通
http://zhidao.baidu.com/link?url=qn78e6uO1HxBwuE8If8JZhRjbQBfr2vWefT-ye4rEJfy4rTs2BoXbqMbyGXnqPpDMUdrdkke0-UM-1ggg0xPM_
百度里只有1个帖子和我的情况一样， 但是题主没有给出解决办法。
希望大神可以给我指导，谢了
回复讨论(解决方案)
贴出你的数据
title中应该是中文，但是显示为数字+小写字母的乱码，如果点击编辑和从其他终端查看本数据库，看到的就不是乱码，如图。
那是十六进制内码，还真没见过这种情况
看看你的表结构
和phpmyadmin有关吧，既然终端查询正常就别管他了呗。
那是十六进制内码，还真没见过这种情况
看看你的表结构
这是数据库结构和表结构
这就对了，你的连接校对（collate）是 utf8_bin
所以也就是这样了
这就对了，你的连接校对（collate）是 utf8_bin
所以也就是这样了
这个数据表都是从朋友那里导出，然后倒入到我的数据库中的，在朋友那里显示就正常的。而且我试了，新建个数据库，把连接校对改成utf8_bin，也是不行
xuzuning 的回答已解决我的问题，在此谢了！
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1386
52
How to set Chinese in Call of Duty: Warzone mobile game
Mar 22, 2024 am 08:41 AM
Call of Duty Warzone is a newly launched mobile game. Many players are very curious about how to set the language of this game to Chinese. In fact, it is very simple. Players only need to download the Chinese language pack, and then You can modify it after using it. The detailed content can be learned in this Chinese setting method introduction. Let us take a look together. How to set the Chinese language for the mobile game Call of Duty: Warzone 1. First enter the game and click the settings icon in the upper right corner of the interface. 2. In the menu bar that appears, find the [Download] option and click it. 3. Select [SIMPLIFIEDCHINESE] (Simplified Chinese) on this page to download the Simplified Chinese installation package. 4. Return to the settings
Setting up Chinese with VSCode: The Complete Guide
Mar 25, 2024 am 11:18 AM
VSCode Setup in Chinese: A Complete Guide In software development, Visual Studio Code (VSCode for short) is a commonly used integrated development environment. For developers who use Chinese, setting VSCode to the Chinese interface can improve work efficiency. This article will provide you with a complete guide, detailing how to set VSCode to a Chinese interface and providing specific code examples. Step 1: Download and install the language pack. After opening VSCode, click on the left
Tips for solving Chinese garbled characters when writing txt files with PHP
Mar 27, 2024 pm 01:18 PM
Tips for solving Chinese garbled characters written by PHP into txt files. With the rapid development of the Internet, PHP, as a widely used programming language, is used by more and more developers. In PHP development, it is often necessary to read and write text files, including txt files that write Chinese content. However, due to encoding format problems, sometimes the written Chinese will appear garbled. This article will introduce some techniques to solve the problem of Chinese garbled characters written into txt files by PHP, and provide specific code examples. Problem analysis in PHP, text
How to deal with garbled characters in Linux terminal
Mar 20, 2024 pm 03:12 PM
How to deal with the problem of garbled characters in the Linux terminal. When using the Linux system, sometimes the text displayed in the terminal will be garbled. This brings inconvenience to us when using the terminal and needs to be dealt with in time. This article will introduce how to deal with some common Linux terminal garbled problems, and provide specific code examples. Problem 1: Garbled Chinese characters on the terminal. Garbled Chinese characters on the terminal are usually caused by incorrect character encoding settings on the terminal. We can solve this problem by modifying the terminal's character encoding settings. #View the current terminal
How to change C++ software to Chinese
Mar 21, 2024 pm 03:07 PM
Steps: For IDE, open the settings, find the language settings, select Chinese, and save the changes. For non-IDE applications, find the setting or option, select the language setting, change to Chinese, and save the changes.
Tips and practices for handling Chinese garbled characters in databases with PHP
Mar 27, 2024 pm 05:21 PM
PHP is a back-end programming language widely used in website development. It has powerful database operation functions and is often used to interact with databases such as MySQL. However, due to the complexity of Chinese character encoding, problems often arise when dealing with Chinese garbled characters in the database. This article will introduce the skills and practices of PHP in handling Chinese garbled characters in databases, including common causes of garbled characters, solutions and specific code examples. Common reasons for garbled characters are incorrect database character set settings: the correct character set needs to be selected when creating the database, such as utf8 or u
Samsung will provide displays for Microsoft's MR headsets, and the devices are expected to be lighter and have clearer displays
Aug 10, 2024 pm 09:45 PM
Recently, Samsung Display and Microsoft signed an important cooperation agreement. According to the agreement, Samsung Display will develop and supply hundreds of thousands of OLEDoS panels for mixed reality (MR) head-mounted devices to Microsoft. Microsoft is developing an MR device for multimedia content such as games and movies. This device is expected to It will be launched after the OLEDoS specifications are finalized, mainly serving the commercial field, and is expected to be delivered as early as 2026. OLEDoS (OLED on Silicon) technology OLEDoS is a new display technology that deposits OLED on a silicon substrate. Compared with traditional glass substrates, it is thinner and has higher pixels. OLEDoS display and ordinary display
Practical Tips: How to use the trim function in PHP to process Chinese spaces
Mar 27, 2024 am 11:27 AM
In PHP programming, spaces are often encountered when processing strings, including Chinese spaces. In actual development, we often use the trim function to remove spaces at both ends of a string, but the processing of Chinese spaces is relatively complicated. This article will introduce how to use the trim function in PHP to process Chinese spaces and provide specific code examples. First, let us understand the types of Chinese spaces. In Chinese, spaces include not only common English spaces (space), but also some other special spaces.
