Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > php mysql utf-8

php mysql utf-8

WBOY
Release： 2016-06-23 14:36:00
Original
962 people have browsed it

解决从Mysql读取中文时的乱码问题：

建表时先加上default charset=utf8;

插入中文数据之前(Mysql命令提示符下)是用set names gb2312;

在php页面中设置是mysql_query('SET NAMES UTF8');

在php页面(已设定为utf8后)中插入中文数据不会出现乱码,应该插入数据库的时候就是以utf8字符集插入中文数据的故不会出现问题!

在php页面前面不要忘了加上header('content-type;text/html;charset=utf-8');

大家在MySQL命令提示符下想查看数据,中文数据有可能是如下 '?????'

所以大家想查看到正确的中文要与插入中文数据一样使用set names gb2312;

引自：

http://www.cnblogs.com/likwo/archive/2011/08/31/2160699.html

Related labels：
php mysql utf-8
source：php.cn
Previous article：Unzip files with PHP Next article：[转] PHP之HTTP_REFERER
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
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
Where should I start to make this page responsive? <!DOCTYPEhtml><htmllang="en"><head><metacharset="UTF-8...
From 2024-04-04 21:21:25
0
1
457
How to render data through DOM instead of through table I have a question about an application I'm creating, I'm using an Oracle database and I'm ...
From 2024-04-04 18:17:27
0
1
3567
Retrieve nested related values ​​in mysql I'm trying to retrieve related values ​​based on multiple entries in a database. I'm very ...
From 2024-04-04 17:29:06
0
2
365
SimpleXML not loading GML data I have the following sample XML data that I want to parse to SimpleXML using PHP: <?xml...
From 2024-04-04 10:04:41
0
1
358
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