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,