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

This article mainly introduces the solution of introducing mysql into txt garbled code, which is very detailed and has a certain reference value. Interested friends must finish reading it!

Mysql import txt garbled solutions: 1, use Navicat Premium to connect to the database; 2, modify the format of the database to utf8;3, re-import the txt file into the database.

This article operating environment: Windows7 system, Navicat Premium15 version, Dell G3 computer.

The solution to importing txt garbled codes into mysql:

First of all, make sure that the txt file is saved in UTF8 format, here you can open it to check the content to confirm the format.

Then use Navicat Premium to connect to the database to see that the data table is in UTF8 format.

Then check the format of the database and make sure it is UTF8.

Continue to see that the columns of the tables in the database are also in UTF8 format.

Query table data, the first empty table does not have a piece of data.

Import the prepared txt file into the database to see if the data is garbled.

Re-query the database to see the data just imported, there is no garbled code, OK shows that we have set up successfully!

The above is all the content of this article "the solution of mysql importing txt garbled code". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.