MySQL Import text file (Excel save) garbled

Issue: The database encoding is saved as a Unicode text file for the Gb2312,excel table.

Execute command Load data local infile "f:/aa.txt" into table "Tb_test"; The imported Chinese content is garbled.

WORKAROUND: The Excel table is saved as a CSV file (separated by ",").

Execute the command load data local infile "f:/aa.csv" into Table "tb_test" Fields terminated by "," lines terminated by "\ n";

Import succeeded.

Reference article:

http://blog.csdn.net/yuanbohx/article/details/6648408

MySQL Import text file (Excel save) garbled