How would you do:
set field='Jim said, "that's crazy."'
you would have to escape the quote somehow. The '\' is the escaper
character.
set field='Jim said, "that\'s crazy."'
That means hat the escape character must also be escaped.
Check the manual for the section on special characters.
Most
Hi everybody,
This seems to be a definite defect in MySql. While inserting a String into
a MySql attribute defined as VARCHAR or VARCHAR BINARY, etc., if a '\' is
present in the String, it is simply disregarded, and the remaining part of the
String gets inserted. For inserting a '\', we hav