Bug #98030 Attempts to import a csv file with BOM fail
Submitted: 19 Dec 2019 8:04 Modified: 19 Dec 2019 9:16
Reporter: John King Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S7 (Test Cases)
Version:8.0.18 OS:Microsoft Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[19 Dec 2019 8:04] John King
Description:
Table Date Import Wizard is not able to recognize a CSV file with BOM (Byte Order Mark, https://en.wikipedia.org/wiki/Byte_order_mark

How to repeat:
0) Prepare a csv utf-8 file, for instance with Excel
1) In MySQL Workbench Create and open a scheme
2) Right-click Tables and select Table Data Import Wizard
3) Select the file created in step 0) and click next twice
An error is reported "Can't analyze file. Please try to change encoding type. If that doesn't help, maybe the file is not; csv, or the file is empty. 
4) Cancel the wizeard
5) open the csv file in a text editor and remove the BOM. I use Notepad++ for that
6) Retry steps 2) - 3) 
 
Now the files is interpreted correctly

Suggested fix:
Interpret the BOM for CSV files and skip these before doing the import.
[19 Dec 2019 9:16] MySQL Verification Team
Hello John King,

Thank you for the bug report.
Please note tat an existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

regards,
Umesh