When operating the mysql database, if garbled characters appear, it is a very troublesome thing. The reasons why MySQL will have Chinese garbled characters are nothing more than the following points: 1. The server itself has a setting problem, for example, it is still stuck at latin1; 2. The language setting problem of the table (including character and collation); 3. The client program (such as php) connection language setting problem. Therefore, it is generally strongly recommended to use utf8! Because utf8 is compatible with all characters in the world! Below we will summarize the solutions to the Chinese garbled problem in mysql database and show it to friends for reference.
mysql database Chinese garbled code
Detailed explanation of the solution to the problem of Chinese garbled characters in Mysql5.7
When using mysql5.7, you will find that garbled characters will appear after writing Chinese to the database through the web end, but when operating SQL directly in the database After the statement is inserted into the data, the Chinese text is displayed normally1) Open the mysql console and enter the command show variables like 'character%';2) Modify the my.ini file 3) After restarting, use the command in the first step to view 4) Enter the command: set names utf8;2.Detailed explanation of the solution to the Chinese garbled database MySQL (picture and text)
MySQL is a very commonly used data database in our projects. But because we need to save Chinese characters in the database, we often encounter database garbled characters. Let’s introduce how to completely solve the problem of Chinese garbled characters in the database. Many answers on the Internet directly set the character encoding of MySQL at the session level. This is a temporary solution rather than a permanent solution. We still need to solve this problem from the source. That is to modify the default configuration file of mysql and change its character set to UTF8 that can use Chinese characters. 3.Quick solution for reading MYSQL Chinese garbled characters with PHP
The Mysql used by foreign hosts in the past was the 4.x series, and it felt better, no matter what There is no garbled code in GBK and UTF-8. Unexpectedly, the MySQL version of the new host is version 5.0. After importing the data, when I read it with Php, it was full of question marks and garbled characters. I remember that I once had the experience of garbled characters when switching. The reason must be the difference between Mysql versions. 4.Solution to Chinese garbled Chinese garbled data read by PHP from mssql json##PHP and web pages use UTF-8 encoding, the database is sql server2008, and the default encoding (936 , that is, GBK encoding),
When reading database data, use the json_encode() that comes with PHP to return to the front end, and the result will not be displayed in Chinese.If you want to insert Chinese into sql server 2008 normally, you also need to add a code: $query = iconv("utf-8", "gbk//ignore", $query);/ /In order to solve the Chinese garbled code problem
5.
mysql Chinese garbled code solution collectionFirst of all, you must specify your upgraded database and table and field character set, generally For example, we use gb2312 or utf8. If you do not use multiple encodings at the same time, you only need to specify the database. You can add the corresponding character set to the SQL statement when building the database, and you can also modify it in phpMyAdmin.
6.
The perfect solution to the Mysql Chinese garbled problemIf the website has been running for a long time and has a lot of old data, and the Simplified Chinese settings cannot be changed, then It is recommended to set the encoding of the page to GBK. The difference between GBK and GB2312 is that GBK can display more characters than GB2312. If you want to display traditional characters in simplified code, you can only use GBK.
Related Questions and Answers1.
The problem of Chinese garbled characters in Mysql under Mac systemHow to solve the Chinese garbled data when rendering the data queried by mysql? 3.
How to solve the Chinese garbled mysql under window? ?1. PHP Chinese website free video tutorial:
"Six Days to Take You to Play with MySQL Video Tutorial"2. Related articles on php Chinese website:
"MySQL 5.1 Reference Manual"The above is the detailed content of Summary of solutions to Chinese garbled characters in mysql database. For more information, please follow other related articles on the PHP Chinese website!

本篇文章给大家带来了关于mysql的相关知识,其中主要介绍了关于架构原理的相关内容,MySQL Server架构自顶向下大致可以分网络连接层、服务层、存储引擎层和系统文件层,下面一起来看一下,希望对大家有帮助。

方法:1、利用right函数,语法为“update 表名 set 指定字段 = right(指定字段, length(指定字段)-1)...”;2、利用substring函数,语法为“select substring(指定字段,2)..”。

mysql的msi与zip版本的区别:1、zip包含的安装程序是一种主动安装,而msi包含的是被installer所用的安装文件以提交请求的方式安装;2、zip是一种数据压缩和文档存储的文件格式,msi是微软格式的安装包。

在mysql中,可以利用char()和REPLACE()函数来替换换行符;REPLACE()函数可以用新字符串替换列中的换行符,而换行符可使用“char(13)”来表示,语法为“replace(字段名,char(13),'新字符串') ”。

转换方法:1、利用cast函数,语法“select * from 表名 order by cast(字段名 as SIGNED)”;2、利用“select * from 表名 order by CONVERT(字段名,SIGNED)”语句。

本篇文章给大家带来了关于mysql的相关知识,其中主要介绍了关于MySQL复制技术的相关问题,包括了异步复制、半同步复制等等内容,下面一起来看一下,希望对大家有帮助。

本篇文章给大家带来了关于mysql的相关知识,其中主要介绍了mysql高级篇的一些问题,包括了索引是什么、索引底层实现等等问题,下面一起来看一下,希望对大家有帮助。

在mysql中,可以利用REGEXP运算符判断数据是否是数字类型,语法为“String REGEXP '[^0-9.]'”;该运算符是正则表达式的缩写,若数据字符中含有数字时,返回的结果是true,反之返回的结果是false。


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

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Dreamweaver Mac version
Visual web development tools

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

Atom editor mac version download
The most popular open source editor

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

SublimeText3 Chinese version
Chinese version, very easy to use
