Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the Chinese garbled code of the character set exported by mysql5 database". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn how to solve the Chinese garbled code of the character set exported by mysql5 database.

Because the export library is installed under windows and uses the utf8 character set, while the import library is installed under linux, the default is Latin or 8859 character set. Therefore, after the data is exported and then imported, there is no problem in displaying the data from the client, but when entering Chinese characters, it is garbled to save. Even if the character set of the newly created exported database is utf8.

The solution I can do now is to reinstall the library, use the source code make install, compile to specify the character set to utf-8, the specific steps to see the installation documentation.

Then after the import, there will be no problem. Some underestimate the character set of Mysql.

At this point, I believe that everyone on the "mysql5 database exported character set how to solve Chinese garbled" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.