Solution to phpMyAdmin displaying Chinese garbled characters

First look at the figure

Solution 1

Php. ini does not have extension = php_mysql.dll

When you encounter this problem, you will usually see it when you open phpmyadmin.

Garbled error

Copy libmysql. dll in php to c: \ windows \ system32 or c: \ winnt \ system32.

Then 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:

 

The code is as follows:	Copy code
'Zh-gb2312 '=> array ('zh | chinese simplified', 'Chinese _ simplified-gb2312 ', 'zh', 'China '),

Change it:

 

The code is as follows:	Copy code
'Zh-gb2312-utf-8 '=> array ('zh | chinese simplified-UTF8', 'Chinese _ simplified-gb2312 ', 'zh', 'China '),

Find again:

 

The code is as follows:	Copy code
'Gb2312' => 'gb2312 ',

Change it:

 

The code is as follows:	Copy code
'Gb2312' => 'latin1 ',

Save the file and exit.

Then open phpMyAdmin from the browser, on the home page select Language: Chinese-Chinese simplified-UTF8

Open the data table and check whether the Chinese characters in the table are 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

The code is as follows:	Copy code
1. 'Zh-gb2312-utf-8 '=> array ('zh | chinese simplified latin1', 'Chinese _ simplified-gb2312', 'zh ',' & #20013; & #25991 ;') 'Zh-gb2312-utf-8 '=> array ('zh | chinese simplified latin1', 'Chinese _ simplified-gb2312 ', 'zh', '& #20013; & #25991 ;')

NOTE: & #20013; & #25991; 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 language-Chinese simplified latin1

Then open the latin1 encoded table and you will see that the garbled characters are no longer there: