phpMyAdmin2.6 above version data garbled problem

Source: Internet
Author: User
Tags filter version phpmyadmin root directory
Data | Problems in phpMyAdmin2.6 above because of the support of multi-language set, let us use phpMyAdmin management database, query out of the Chinese are garbled, but in our PHP program calls without these problems.

It seems that there is a problem with the configuration of phpMyAdmin2.6, in order to solve this problem, I googled the relevant information, such a lot of problems, but not one can be solved, is really no way, it seems only to solve their own hands.

Finally spent half a day of time, finally found a more eclectic way to solve.

To the root directory of phpMyAdmin2.6, open the following file:
1, to find a "zh-gb2312" that line, the ' zh-gb2312 ' changed to ' Zh-gb2312-utf-8 '
Why do you add this? That's because the server will filter out the language without "-utf-8", in line 168th of libraries/database_interface.lib.php, according to English: "To prevent confusion",:<
Or if you don't change ' zh-gb2312 ' to ' zh-gb2312-utf-8 ', you can remove the filter. Just get rid of that if it's OK.

2, find "$mysql _charset_map = Array (" That line
Put ' gb2312 ' => ' gb2312 ',
Changed to ' gb2312 ' => ' latin1 ',

Save, OK, enter phpMyAdmin management, select language Chinese Simplified (zh-gb2312-utf-8)
Take a look at your Chinese data again.

So, my solution is only to modify the libraries/select_lang.lib.php this file in the two words on the line, more convenient and quick, haha.

Related Article

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.