MySQL Bugs: #98030: Attempts to import a csv file with BOM fail

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:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

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.

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