Solve the Problem of PHP accessing MySQL 4.1 garbled characters

Solve the Problem of PHP accessing MySQL 4.1 garbled characters The multi-language support introduced since MySQL 4.1 is indeed great, and some features have exceeded other database tutorial systems. However, during the test, I found that using a PHP statement before MySQL 4.1 to operate the MySQL database may cause garbled characters, even if the table character set is set. I read chapter 10 "Character Set Support" in the new MySQL online manual and finally found the solution and passed the test. MySQL 4.1 Character Set Support has two aspects: Character set and Collation ). The support for character sets is refined to four levels: server, database, table, and connection ). You can run the following two commands to view the character set and sorting method settings of the system: Mysql> show variables like 'character _ set _ % '; + -------------------------- + ---------------------------- + | Variable_name | Value | + -------------------------- + ---------------------------- + | Character_set_client | latin1 | character_set_connection | latin1 | Character_set_database | latin1 | character_set_results | latin1 | Character_set_server | latin1 | character_set_system | utf8 | Character_sets_dir |/usr/share/mysql/charsets/ | + -------------------------- + ---------------------------- + 7 rows in set (0.00 sec) Mysql> show variables like 'collation _ % '; + ---------------------- + ------------------- + | Variable_name | Value | + ---------------------- + ------------------- + | Collation_connection | latin1_swedish_ci | collation_database | Latin1_swedish_ci | collation_server | latin1_swedish_ci | + ---------------------- + ------------------- + 3 rows in set (0.00 sec) The values listed above are the default values of the system. (It's strange how latin1's Swedish sorting method is used by default )... When we access the MySQL database through PHP in the original way, even if the default Character Set of the table is set to utf8 and the query is sent through the UTF-8 encoding, you will find that the database is still garbled. The problem lies in the connection layer. The solution is to execute the following statement before sending the query: Set names 'utf8 '; It is equivalent to the following three commands: SET character_set_client = utf8; SET character_set_results = utf8; SET character_set_connection = utf8; Try again. Is it normal? Pai_^ Enjoy!