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

解析：MySQL 5.0.16乱码问题的解决方法_MySQL

WBOY
Release： 2016-06-01 14:04:34
Original
1066 people have browsed it
 

 

MySQL 5.0.16乱码问题的解决方法

问：怎样解决MySQL 5.0.16的乱码问题？

答：MySQL 5.0.16的乱码问题可以用下面的方法解决：

 

1 设置phpMyAdmin

Language:Chinese simplified (zh-utf-8)

MySQL 字符集：UTF-8 Unicode (utf8)

MySQL 连接校对 gbk_chinese_ci

 

2 创建数据库时

整理设置成 gbk_chinese_ci

 

3 用SQL建立表中

ENGINE=MyISAM DEFAULT CHARSET=gbk;

ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=40 ;

 

4 检查表结构中

varchar(100) 的整理属性为gbk_chinese_ci

其它类型的整理属性为空。

 

5 代码中加上

$db->query("SET CHARACTER SET GBK"); Linux下需要，Windows下则不需要。

此种操作相当于Connection Character Sets and Collations

Related labels：
mysql method solve parse question
source：php.cn
Previous article：MySQL数据库中导入导出方法以及工具介绍_MySQL Next article：教你怎样正确配置MySQL数据库SQL Mail_MySQL
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
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
How to solve the mysterious white space at the bottom of the page in CSS I'm trying to build a simple webpage using Bootstrap and D3, but I don't know how to get r...
From 2024-04-06 20:22:15
0
1
454
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
How to get the first name from customer_name column selectsubstring(custommer_name,1,instr(custmer_name,''))asfirst_namefromsales.customers; t...
From 2024-04-06 17:43:30
0
2
433
Generate default values ​​and CSS variables using SCSS I'm implementing website styling. For legacy support reasons, I need to support IE11, at l...
From 2024-04-06 17:46:54
0
1
355
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！