Home > database >  Consult: MySQL Workbeach import CSV, submitted to the coding errors (there are Chinese, in the CSV f
Consult: MySQL Workbeach import CSV, submitted to the coding errors (there are Chinese, in the CSV f

Time:10-05

Want to use the MySQL Workbeach import the commonly used several tables, practice with SQL data, results in the first step is card died, has been reported the error, baidu's half a day, try the baidu to a variety of methods, save into utf-8 format, the code with notepad to no BOM CSV format, into a full English path, various methods are all tried, the somebody else say, all useful all not to me! Depressed, also changed the format, the data must be CSV format, certainly is not empty, but is stuck in this step,
Later, the CSV file contains Chinese characters of columns and rows all deleted, can the normal import, converted to utf-8, in notepad, Chinese character display is normal, but directly open the CSV, Chinese characters were garbled, don't know why the Chinese character will affect the normal import,
Data import, more don't talk behind the operation data, always meet these pits, and don't know how to solve, it's too difficult ~ ~ ~ have a passing under the great god hope can help, thank ~ ~

  • Related