Description:
Using the Migration Wizard, I'm unable to import any MS Access data that has a single quote in it, as in:
they're
I get the following error in the log:
13:29:16 [INF][ copytable]: Connection to MySQL opened
13:29:16 [INF][ copytable]: Setting charset for source data to latin1
13:29:17 [INF][ copytable]: Statement execution failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's withdrawn 6/30/2013'),('4045','Optra M41x',206.000000,'M41X',1,1,'Withdrawn','' at line 1:
I'm importing from Access 2010 32bit using the 32bit MS ODBC driver. I'm importing into 5.7.11 running on AWS Linux instance.
I don't see any wizard options to handle special characters, nor were there any options in the Windows ODBC driver set up. I did see some ANSI options on the Target RDBMS screen, I tried that and it didn't help.
How to repeat:
Create an MS Access table with a single column. Insert a row of data that contains a single quote. Run the migration wizard.
Suggested fix:
Give the wizard the ability to search for, and properly escape, special characters
Description: Using the Migration Wizard, I'm unable to import any MS Access data that has a single quote in it, as in: they're I get the following error in the log: 13:29:16 [INF][ copytable]: Connection to MySQL opened 13:29:16 [INF][ copytable]: Setting charset for source data to latin1 13:29:17 [INF][ copytable]: Statement execution failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's withdrawn 6/30/2013'),('4045','Optra M41x',206.000000,'M41X',1,1,'Withdrawn','' at line 1: I'm importing from Access 2010 32bit using the 32bit MS ODBC driver. I'm importing into 5.7.11 running on AWS Linux instance. I don't see any wizard options to handle special characters, nor were there any options in the Windows ODBC driver set up. I did see some ANSI options on the Target RDBMS screen, I tried that and it didn't help. How to repeat: Create an MS Access table with a single column. Insert a row of data that contains a single quote. Run the migration wizard. Suggested fix: Give the wizard the ability to search for, and properly escape, special characters