Bug #91021 If data contains single quotes, import wizard fails to handle double quotes
Submitted: 25 May 2018 7:45 Modified: 28 May 2018 13:01
Reporter: NA Morty Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.11 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[25 May 2018 7:45] NA Morty
Description:
If data contains single quotes, import wizard fails to handle double quotes.

https://i.stack.imgur.com/zmFh1.png
https://i.stack.imgur.com/qlzcs.png
https://i.stack.imgur.com/Vb9ts.png

Navicat works fine.

How to repeat:
1. Create a utf8 encoding csv with MS Excel.
2. Input some data, make sure that record contains single quotes comes before record contains double quotes.
[25 May 2018 12:38] Chiranjeevi Battula
Hello Morty,

Thank you for the bug report.
I could not repeat the issue at our end using with MySQL Workbench 8.0.11 version on Windows 10.
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.
[25 May 2018 12:39] Chiranjeevi Battula
Screenshot

Attachment: Bug_91021.png (image/png, text), 48.06 KiB.

[26 May 2018 1:23] NA Morty
Aren't data 4 and 5 different from the one you see in Excel? The double quotes
[28 May 2018 13:01] Chiranjeevi Battula
Hello Morty,

Thank you for the feedback.
Verified this behavior on MySQL Workbench in 8.0.11 version.

Thanks,
Chiranjeevi.