PZercom
2022-09-07T01:10:26Z
Hi there;

I'm trying to store Outlook emails in a mysql database, including the html_body field. But when the program encounters a single quote or apostrophe ('), it misinterprets what follows and gives an error message.

Is there a way to build "htmlspecialchars" into the mysql command, or something similar?

I'm using mysql ODBC driver 3.51 driver


Thanks.
Administrator
2022-09-07T01:15:14Z
Hello,

I think its related to a bug in mySQL ODBC driver, if your 3.5 driver works, except the apostrophes, maybe they solved it in other version inside the 3.51 releases, you can also try 5.2.7 was pretty stable years ago, but depends on how old your server is.
PZercom
2022-09-07T01:19:22Z
Thanks again. I got my process working with mysql ODBC driver 5.3.14