Mysql中文乱码问题完美解决方案(国外英文资料).docVIP

Mysql中文乱码问题完美解决方案(国外英文资料) Reproduced: Mysql Chinese garbled solution The first method is a brilliant summary: Often change the virtual host, and the MYSQL version of each service provider is different, when imported data, there will always be garbled and other problems can not be displayed, check a lot of information, summed up a bit of their own skills: WINDOWS, import should be like this Using the MYSQL command Enter the MySQL command in the DOS bin directory, enter the MySQL -uroot -p password database name to restore the database, for example, we have a name for the D disk to restore test.sql database to the local test2 to the database, then this: MySQL -uroot -p test2 password before the foreign host using the Mysql is 4.x the feeling is still relatively good, both GBK and UTF-8 are not garbled, did not expect the new host Mysql is the 5 version of the import data, read out by Php is a piece of garbage, mark, remember that I used to have a switch garbled experience is definitely the problem the difference between the Mysql version. To check the information, found a solution, is to add SET NAMES UTF8 behind mysql_connect, can make the UTF8 SET NAMES database to eliminate garbled, GBK is used for the GBK database, the code is as follows: $mysql_mylink = mysql_connect ($mysql_host, $mysql_user, $mysql_pass); Mysql_query (SET NAMESGBK); ? The database character set is UTF-8 The connection statement uses this Mysql_query (SET NAMESUTF8); Mysql_query (SET CHARACTER SET UTF8); Mysql_query (SET CHARACTER_SET_RESULTS=UTF8); Another way is that if your own machine, you can change the MYSQL character set, usually in the two versions of MYSQ4 and MYSQL5 in effect. The second method: very good explanation, you can try MySQL garbled processing summary: (1) Java handles normal Chinese characters, and shows garbled characters in CMD client ?? (2) the length of the field is long enough, but when inserting Chinese characters, com.mysql.jdbc.MysqlDataTruncation: Data, truncation: