In order to support the Chinese display, the MySQL service uses UTF8 encoding, uses navicate to connect the database, in order to maintain the encoding consistency, the connection also uses UTF8 encoding, as shown in:
650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/7F/12/wKiom1cR_KyRk9aGAADtg2bYolI646.png "title=" screen shot 2016-04-16 pm 4.47.43.png "width=" height= "284" border= "0" hspace= "0" vspace= "0" style= "WIDTH:400PX;HEIGHT:284PX;" alt= "Wkiom1cr_kyrk9agaadtg2byoli646.png"/>
The connection is complete, the table definition of note information has been garbled, at first thought to be a MySQL server problem, a variety of settings without fruit! Now look at the character set used:
Show variables like ' char% ';
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/7F/12/wKiom1cSAFrjPiaTAADIrpChiXw104.png "title=" screen shot 2016-04-16 pm 5.04.31.png "width=" height= "171" border= "0" hspace= "0" vspace= "0" style= "width:300px;height:171px" alt= "Wkiom1csafrjpiataadirpchixw104.png"/>
found that client,connection and results character set is a problem, was troubled by the problem for a long time, unexpected, want to navicate character set to Automatic, problem solving!
650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/7F/12/wKiom1cSAU-hXiplAADvuR9kJv4291.png "title=" screen shot 2016-04-16 pm 5.08.36.png "width=" height= "203" border= "0" hspace= "0" vspace= "0" style= "width:300px;height:203px" alt= "Wkiom1csau-hxiplaadvur9kjv4291.png"/>
Now look again at using character sets
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/7F/12/wKiom1cSAcfD-Xd0AACllP-fJeo701.png "title=" screen shot 2016-04-16 pm 5.11.17.png "width=" height= "131" border= "0" hspace= "0" vspace= "0" style= "width:300px;height:131px" alt= "Wkiom1csacfd-xd0aacllp-fjeo701.png"/>
This article is from the "Technical Achievement Dream" blog, please be sure to keep this source http://houenxun.blog.51cto.com/3958763/1764530
Navicate for MySQL Chinese garbled