MySQL client garbled

Install MySQL today, after the installation is completed, through the client query data query, found that Chinese is garbled. It's so helpless,

Sit down and study slowly, the process is probably as follows:

First use the MySQL tool to query the database, to see if the corresponding table is UTF8, will not garbled.

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/88/8A/wKiom1f7InGCnZNBAAAgaFM6jpw840.png-wh_500x0-wm_3 -wmp_4-s_204413426.png "title=" 1.png "alt=" Wkiom1f7ingcnznbaaagafm6jpw840.png-wh_50 "/>

Remote use of client discovery is not garbled

What is the encoding of the field in the View table

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/88/8A/wKiom1f7IsPB9wA_AACZHuj7TAo840.jpg-wh_500x0-wm_3 -wmp_4-s_3351120814.jpg "title=" 2.jpg "alt=" Wkiom1f7ispb9wa_aaczhuj7tao840.jpg-wh_50 "/>

There's no problem with the character encoding of the table, so what's the problem?

View the encoding for the local MySQL client:

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/88/86/wKioL1f7IwmhAjvPAABjMRS1vkA962.jpg-wh_500x0-wm_3 -wmp_4-s_2526524909.jpg "title=" 3.jpg "alt=" Wkiol1f7iwmhajvpaabjmrs1vka962.jpg-wh_50 "/>

Viewed the MySQL client's code and found the path

To modify the client encoding of the MySQL configuration file:

650) this.width=650; "src=" http://s5.51cto.com/wyfs02/M00/88/8A/wKiom1f7I1fgxnTwAAATv87dn10115.jpg "title=" 4.jpg " alt= "Wkiom1f7i1fgxntwaaatv87dn10115.jpg"/>

Add code to client in my.cnf, restart MySQL service, re-detect

650) this.width=650; "src=" http://s5.51cto.com/wyfs02/M01/88/86/wKioL1f7I6CDGCtdAABd0cUP6oI495.jpg "title=" 5.jpg " alt= "Wkiol1f7i6cdgctdaabd0cup6oi495.jpg"/>

Alas bite, the code has changed. Can you look at Chinese in the following test?

650) this.width=650; "src=" http://s5.51cto.com/wyfs02/M01/88/86/wKioL1f7JA6ih7R1AAAV8mcO9C0151.jpg "title=" 6.jpg " alt= "Wkiol1f7ja6ih7r1aaav8mco9c0151.jpg"/>

It's done.

This article is from the "Loyalty" blog, make sure to keep this source http://xinsir.blog.51cto.com/5038915/1860173

MySQL client garbled