search
HomeBackend DevelopmentPHP TutorialAbout the problem of garbled characters in Mysql5_PHP tutorial
About the problem of garbled characters in Mysql5_PHP tutorialJul 13, 2016 pm 05:37 PM
ChineseGarbled charactersaboutAppearofsolvequestion

I have been exposed to Mysql5 several times before, but I have been using 4.0 because the Chinese garbled characters cannot be solved. Mysql5 supports multiple encoding methods. As long as the encoding stored and read are consistent, garbled characters will not be generated, for example, both are gb2312.
1. Specify the encoding gb2312
in the web page
It is best to execute it before executing the SQL statement:
mysql_query("SET NAMES GB2312");


2. Modify the apache configuration file httpd.conf
AddDefaultCharset GB2312
3. Modify mysql5 configuration file
default_character_set = gb2312

This method was successfully tested under FC5 and Windows XP.

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/486548.htmlTechArticleI have been exposed to Mysql5 several times before, but I have been using 4.0 because the Chinese garbled characters cannot be solved. mysql5 supports multiple encoding methods. As long as the encoding stored and read are consistent, garbled characters will not be generated, such as...
Statement
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
php 导入csv乱码问题怎么办php 导入csv乱码问题怎么办Nov 21, 2022 am 09:32 AM

php导入csv乱码问题的解决办法:1、构造一个解析函数“function tb_str_getcsv($string, $delimiter=',', $enclosure='"') {...}”;2、读取文件到变量;3、通过“substr($s,2)”去掉BOM头即可。

cmd php乱码怎么办cmd php乱码怎么办Nov 22, 2022 am 10:29 AM

cmd php乱码的解决办法:1、在windows平台的cmd或shellpower中,执行php脚本并检查是否乱码;2、通过在php脚本里执行“exec("CHCP 65001");”命令去修改当前页码字符集即可。

php+fread()乱码怎么办php+fread()乱码怎么办Jan 18, 2023 am 10:21 AM

php+fread()乱码是因为输出页面的编码和被读文件的编码不一致,其解决办法:1、打开相应的PHP文件;2、通过fread函数读取文件;3、通过“iconv('gbk', 'utf-8', $data)”方法将读取的内容转码即可。

如何解决php写入数据库中文乱码问题如何解决php写入数据库中文乱码问题Sep 25, 2021 am 10:29 AM

php写入数据库中文乱码的解决办法:1、创建数据库并设置“utf8_general_ci”编码;2、用PHP读写数据库,然后设置“mysql_query("set names 'utf8'");”即可。

wordpress后台乱码怎么办wordpress后台乱码怎么办Feb 03, 2023 pm 01:48 PM

wordpress后台乱码的解决办法:1、在wordpress的“wp-admin”文件夹下找到“admin.header.php”文件;2、将“charset”属性值设置为“UTF-8”格式即可恢复正常。

mysql注释乱码问题怎么解决mysql注释乱码问题怎么解决Feb 13, 2023 am 09:44 AM

mysql注释乱码问题的解决办法:1、通过“show variables like '%colla%';show variables like '%char%';”命令查看数据库与服务端的字符集设置;2、通过“set character_set_client=utf8;”设置结果集为utf8即可。

php dompdf中文乱码怎么办php dompdf中文乱码怎么办Jan 18, 2023 am 10:34 AM

php dompdf中文乱码的解决办法:1、打开前端文件;2、通过设置“@font-face {font-family:ttt;src: url(/static/font/simkai.ttf)}”引用中文字体;3、删除“dompdf_font_family_cache.php”即可。

css浏览器乱码怎么办css浏览器乱码怎么办Jan 28, 2023 pm 01:55 PM

css浏览器乱码的解决办法:1、将CSS指定编码类型如“@charset "utf-8"”;2、在css中使用别名,绕开使用中文,从而避免乱码,其正常代码如“font-family:"SimHei"”。

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft