I'm a bit new to mySQL and having a problem with quote marks. I'm inserting into a table via a ColdFusion form page, and data containing quote marks seem to not be inserted. I don't get an error -- all subsequent fields fill up fine -- but the quoted data seem to get truncated. For example:
This is a "long" book.
gets added as:
This is a
Any thoughts? I've tried escaping with a backslash as well as double-quotes.