Import micro-blog data

Import micro-blog data, with Navicat, got a long time, exhausted me

1, need to import an Excel table, which contains Chinese characters

Save excel in CSV format first, save CSV as TXT, and save txt as UTF8 encoded TXT format

2, import do not directly import the table, but their own new table, define the table each column and type, and the following character set selected as UTF8, sorting method I chose to utf8-general-ci, do not know if there is no use

3, the new table after the introduction of the table, the character of the selection is "" when it can be used, after the guide to set the corresponding column, that is, the table of columns in the name and the table of their own definition of each column corresponding to it.

4. Be careful not to overflow when setting the field type

Import micro-blog data