AnsweredAssumed Answered

Text containing apostrophes not accepted when sent from FileMaker to MySql via ODBC

Question asked by Polarpro on Apr 29, 2016
Latest reply on Sep 17, 2018 by cbishop

Hey all,


we transfer data from a FileMaker solution to an MySql database (using ODBC and the Actual Technologies driver for Mac OS). We now found out that apostrophes in text fields are not accepted by an MySql database (for security reasons or similar).


As we are most likely not the first ones to run into this problem: Has anybody an idea how we could solve this? How can we make sure that text containing apostrophes sent from our FileMaker solution is accepted by MySql?


Btw, this is the error message we receive with Get ( LastODBCError ):

1408 You have an error in your SQL syntax; check the manual that correspond


Thanks a lot,