Home > Article > Backend Development > How to solve the problem of garbled characters when php reads data from the database
When using PHP to write a website or application, sometimes garbled characters appear when reading data from the database. This is a very common problem, but it is very annoying. In this article, we will explore the causes of garbled data when reading data from the database in PHP and how to fix it.
Cause of garbled characters
Transfer data between the application and the database If they use different character sets, the data will be garbled. For example, if the database uses the UTF-8 character set and the application uses the ISO-8859-1 character set, the data obtained from the database will be garbled.
If the database connection character set is not set, the server's character set will be used by default. If the character set of the server is inconsistent with the character set of the database, garbled characters will appear during data transmission.
Sometimes, the data saved in the database may be mixed character sets, such as UTF-8 and GBK encoding in the same field character of. In this case, garbled characters will appear when reading data.
Solution
In MySQL, you can change the database character set using the following command:
ALTER DATABASE database_name DEFAULT CHARACTER SET utf8;
For applications, you can set the character set to UTF-8 in PHP using the following command:
mysqli_set_charset($link, "utf8");
In MySQL, you can set the character set when connecting to the database:
$link = mysqli_connect("localhost", "user", "password", "dbname"); mysqli_set_charset($link, "utf8");
Data in MySQL can be converted to UTF-8 using the following command:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Alternatively, text can be converted to UTF-8 in PHP using the following code:
$data = mb_convert_encoding($data, "UTF-8", "auto");
Conclusion
For the problem of garbled data read by PHP from the database, it may be that the character set is inconsistent during data transmission, the database connection character set is not set, or the character set in the database confusion. To avoid these problems, you can set the database and application to the same character set, and set the character set when connecting to the database. If garbled characters still appear, you can try cleaning up the data in the database and converting it all to UTF-8.
The above is the detailed content of How to solve the problem of garbled characters when php reads data from the database. For more information, please follow other related articles on the PHP Chinese website!