Solution to phpMyAdmin displaying Chinese garbled characters

According to my experience, garbled characters in php and mysql are generally document encoding problems, such as gbk, uft8, and gb2312, which are inconsistent with page encoding. Solution 1: no extensionphp_mysqld in phpini

According to my experience, garbled characters in php and mysql are generally document encoding problems, such as gbk, uft8, and gb2312, which are inconsistent with page encoding.

Solution 1:Php. ini does not have extension = php_mysql.dll

When you encounter this problem, you may encounter a garbled error when you open phpmyadmin. copy the dll to c: \ windows \ system32 or c: \ winnt \ system32, and restart the computer.

Solution 2:The following is my modification process:

Open the libraries/select_lang.lib.php file in the phpMyAdmin root directory; find: 'zh-gb2312 '=> array ('zh | chinese simplified', 'Chinese _ simplified-gb2312 ', 'zh ', change it to 'zh-gb2312-utf-8 '=> array ('zh | chinese simplified-UTF8', 'Chinese _ simplified-gb2312 ', 'zh', 'China '), find 'gb2312' => 'gb2312' and change it to 'gb2312' => 'latin1'. Save the file and exit.

Then open phpMyAdmin from the browser, in the home page select Language: Chinese-Chinese simplified-UTF8, and then open the data table to see whether the Chinese inside can be properly displayed :)

Solution 3:By default, tables in Mysql use latin1 encoding. However, if the content is added using mysql commands, it is generally inserted using gb2312 encoding. the language is directly used in phpmyadmin: chinese-Chinese simplified: garbled characters

1. open libraries/select_lang.lib.php, search for the $ available_ages array, and add a data item at the end:

Php code

1. 'Zh-gb2312-utf-8 '=> array ('zh | chinese simplified latin1', 'Chinese _ simplified-gb2312 ', 'zh', 'China ')
2. 'Zh-gb2312-utf-8 '=> array ('zh | chinese simplified latin1', 'Chinese _ simplified-gb2312 ', 'zh', 'China ')
3. // Note: Chinese represents the word "Chinese.

2. search $ mysql_charset_map and find the array. change the value 'gb2312' => 'gb2312 'to 'gb2312' => 'latin1 '.

3. open phpmyadmin again. Select Chinese-Chinese simplified latin1 as the language. then open the latin1 encoded table and you will see that the garbled text is no longer available.