Usage scenarios:
1. The CSV file using the excel "CSV utf-8 (comma-separated)" form;
2. Database, table, field character set all set to utf8,
3. The workbench of the latest version of the

The workbench error message:
1. Can 't analyze the file, do try to encoding type. If that doesn' t help, maybe this file is not: the CSV, or the file is empty.

Other details:
1. The other day to import the CSV file without any problem, may be done during operation,
2. Don't work, a lot of online tutorials reference,

CodePudding user response:

No file was detected, try on mysql default input and output folder, can see

CodePudding user response:

Similarly, those bloggers too water, they don't understand, where is the problem still let's switch to utf-8, already with utf-8 also useless,

CodePudding user response:

Me too, stuck in this step, I an error is:
An unhandled exception error: "ascil" codec can't decode location for O: serial number is not within the scope of the byte Oxe6 (128).

CodePudding user response:

Comma became Chinese comma?

CodePudding user response:

Is the cause of the file format, excel save Settings utf8 - CSV format is utf with BOM format, use notepad + + to open the file does not contain converted to BOM utf format, I took two hours to solve the reason,

CodePudding user response:

refer to 6th floor mmmmmmmmmiao response:

is the cause of the file format, excel save Settings utf8 - CSV format is utf with BOM format, use notepad + + to open the file does not contain converted to BOM utf format, I took two hours to solve the reason,

Can also use notepad to open the file and translated into excluding BOM utf-8 format