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: