Bug #96387 Can't import file via Table Data Import Wizard
Submitted: 31 Jul 2019 14:56 Modified: 11 Aug 2019 10:24
Reporter: Rami Amiry Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.16, 8.0.17 OS:Windows (Microsoft Windows 10 Home)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[31 Jul 2019 14:56] Rami Amiry
Description:
After upgrading Workbench to version 8.0.16 I can't import file with Hebrew characters. I'm getting error "Can't analyse the file. Please try to change encoding type...."
The input file(UTF8) was created via Excel and then I removed the BOM via noteped++ but still getting the error. 
I created test file with only English and didn't get the error. Then, I edited the file and inserted one Hebrew character and got the error. 
My DEFAULT CHARACTER SET = utf8 collate = utf8_general_ci.

How to repeat:
create table bar 
(item varchar(50), amount int, sell_date date, price DECIMAL(10,2), final_price DECIMAL(10,2), employee varchar(50), category varchar(50))
DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci;

And import file with values:
stאאlla,1,2019-07-01,32,32,ronen,beer
[31 Jul 2019 15:21] Rami Amiry
UTF8 file with Hebrew characters

Attachment: bar_utf8_hebrew.csv (application/vnd.ms-excel, text), 37 bytes.

[1 Aug 2019 6:47] MySQL Verification Team
Hello Rami Amiry,

Thank you for the bug report.

regards,
Umesh
[11 Aug 2019 10:24] Rami Amiry
Can anyone please help how to workaround these issue?