Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > body text

MySQL 5.0.16 乱码问题处理办法_MySQL

WBOY
Release： 2016-06-01 14:05:09
Original
991 people have browsed it

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：
Method deal with tidy question
source：php.cn
Previous article：查看当前进程,或死锁进程,并能自动杀掉死进程_MySQL Next article：MySQL中的mysqldump命令使用详解_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
Can a workerpool declared in multiple routes still maintain its cpu usage without caring about the threshold I'm hoping to find a node.js system with a workerpool to handle CPU intensive tasks, but I...
From 2024-04-06 19:54:23
0
1
444
In mobile view, how can I close this navigation bar when the user clicks on the link? When the user clicks a link to browse the website, the navigation bar does not close? I've...
From 2024-04-06 19:23:03
0
1
411
MySQL: "Select text from... as <variable here or subquery>" I have the following table with the following data: id text language 1 german text german ...
From 2024-04-06 19:25:54
0
2
529
What are the best practices for displaying version information in web applications? I'm developing a web application. What are the best practices for displaying version infor...
From 2024-04-06 19:13:16
0
2
476
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