This afternoon, I have been working on the Mysql Character Set Problem. Using command line load to import text file data, Chinese characters are garbled.
So I checked the default encoding of Mysql, and the input show variables like 'character _ set _ % ';,
I think it's also utf8,
The characters in the database, table, and field settings are in utf8 format. It has been a long time to struggle with this issue. It turns out that it is not a problem with Mysql, so it should be due to a problem with the data encoding of the source file, therefore, the character format of Windows Default txt text is gbk. After finding the problem, you can change the character of the source file. However, the method on the internet is quite troublesome. Here we will teach you how to use a tool to change it.
Download link for everyone http://download.csdn.net/detail/zsb190623/6900839
I wrote a blog for everyone who stayed up late. Everyone remembers it!