How to solve the problem of mysql blob garbled characters

Solution to garbled mysql blob: 1. Find the my.ini file in the mysql installation directory; 2. Comment out "sql-mode="STRICT_TRANS_TABLES...""; 3. Convert the blob field type It can be of text type.

The operating environment of this article: Windows 7 system, mysql version 5.5, Dell G3 computer.

How to solve the mysql blob garbled problem?

mysql data blob type Chinese garbled code

1. Find the my.ini file in the mysql installation directory

Comment out

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

and add it in front Comment out the # symbol above,

2. Just convert the blob field type to text type.

Recommended learning: "mysql video tutorial"

The above is the detailed content of How to solve the problem of mysql blob garbled characters. For more information, please follow other related articles on the PHP Chinese website!