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.

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.

Thanks again. I got my process working with mysql ODBC driver 5.3.14