Home Backend Development PHP Tutorial mysql乱码解决办法

mysql乱码解决办法

Jun 13, 2016 pm 12:17 PM
character default mysql nbsp

mysql乱码
我把mysql里的my.ini的编码都设置成utf-8

<br />[client]<br />port=3306<br />default-character-set=utf8<br /><br />[mysql]<br />default-character-set=utf8<br /><br />[mysqld]<br />#绑定IPv4和3306端口<br />bind-address = 127.0.0.1<br />port = 3306<br /><br />default-character-set=utf8<br /><br /># 设置mysql的安装目录<br />basedir=D:/MySQL/mysql-5.6.21-win32<br /><br /># 设置mysql数据库的数据的存放目录<br />datadir=D:/MySQL/mysql-5.6.21-win32/data<br /><br /># 允许最大连接数<br />max_connections=200<br />
Copy after login


但显示出来的不是utf-8 重启后也没效果


我在网上试了好几种方法都解决不了乱码的问题,求高人指教
------解决思路----------------------
还是那话:数据库不是为你一个人服务的,所以应该是你去适应环境,而不是环境来适应你!
所以不要去改动 MySQL 的默认设置去适应你的要求
如果你一定要这样做(或是作为学习),应从安装 MySQL 开始
在 MySQL 的安装过程中有一个扩展选项,用来设置 MySQL 的默认字符集
安装完之后,你再去观察正确的字符集组合设置是怎样的

在使用 MySQL 时,是不能改变 MySQL 的默认设置的(因为你的改动可能会影响到几个、几十个甚至几百个人的工作)
你能改变的只是专属于你的库、表、字段的字符集设置,而且是一旦改了,就不要再动了。否则会直接影响到你自己在不同时期的工作

原则是:
含有中文的字段应设置为宽字符集(gbk、utf8、ucs-2...)任何一种都可以
在连接 MySQL 后执行 set name XXX 指令(XXX 为你程序文件所使用字符集),通知 MySQL 以何种字符集与你会话


------解决思路----------------------
连接数据库的时候添加
mysql_query("set names utf8")
检查项目编码,数据库,表,字段的编码是否都统一

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

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 ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP's big data structure processing skills PHP's big data structure processing skills May 08, 2024 am 10:24 AM

Big data structure processing skills: Chunking: Break down the data set and process it in chunks to reduce memory consumption. Generator: Generate data items one by one without loading the entire data set, suitable for unlimited data sets. Streaming: Read files or query results line by line, suitable for large files or remote data. External storage: For very large data sets, store the data in a database or NoSQL.

How to optimize MySQL query performance in PHP? How to optimize MySQL query performance in PHP? Jun 03, 2024 pm 08:11 PM

MySQL query performance can be optimized by building indexes that reduce lookup time from linear complexity to logarithmic complexity. Use PreparedStatements to prevent SQL injection and improve query performance. Limit query results and reduce the amount of data processed by the server. Optimize join queries, including using appropriate join types, creating indexes, and considering using subqueries. Analyze queries to identify bottlenecks; use caching to reduce database load; optimize PHP code to minimize overhead.

How to use MySQL backup and restore in PHP? How to use MySQL backup and restore in PHP? Jun 03, 2024 pm 12:19 PM

Backing up and restoring a MySQL database in PHP can be achieved by following these steps: Back up the database: Use the mysqldump command to dump the database into a SQL file. Restore database: Use the mysql command to restore the database from SQL files.

How to insert data into a MySQL table using PHP? How to insert data into a MySQL table using PHP? Jun 02, 2024 pm 02:26 PM

How to insert data into MySQL table? Connect to the database: Use mysqli to establish a connection to the database. Prepare the SQL query: Write an INSERT statement to specify the columns and values ​​to be inserted. Execute query: Use the query() method to execute the insertion query. If successful, a confirmation message will be output.

How to fix mysql_native_password not loaded errors on MySQL 8.4 How to fix mysql_native_password not loaded errors on MySQL 8.4 Dec 09, 2024 am 11:42 AM

One of the major changes introduced in MySQL 8.4 (the latest LTS release as of 2024) is that the &quot;MySQL Native Password&quot; plugin is no longer enabled by default. Further, MySQL 9.0 removes this plugin completely. This change affects PHP and other app

How to use MySQL stored procedures in PHP? How to use MySQL stored procedures in PHP? Jun 02, 2024 pm 02:13 PM

To use MySQL stored procedures in PHP: Use PDO or the MySQLi extension to connect to a MySQL database. Prepare the statement to call the stored procedure. Execute the stored procedure. Process the result set (if the stored procedure returns results). Close the database connection.

How to create a MySQL table using PHP? How to create a MySQL table using PHP? Jun 04, 2024 pm 01:57 PM

Creating a MySQL table using PHP requires the following steps: Connect to the database. Create the database if it does not exist. Select a database. Create table. Execute the query. Close the connection.

The difference between oracle database and mysql The difference between oracle database and mysql May 10, 2024 am 01:54 AM

Oracle database and MySQL are both databases based on the relational model, but Oracle is superior in terms of compatibility, scalability, data types and security; while MySQL focuses on speed and flexibility and is more suitable for small to medium-sized data sets. . ① Oracle provides a wide range of data types, ② provides advanced security features, ③ is suitable for enterprise-level applications; ① MySQL supports NoSQL data types, ② has fewer security measures, and ③ is suitable for small to medium-sized applications.

See all articles