Re: Problem in MySql while inserting '\'

2002-02-15 Thread Gerald Clark
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

Problem in MySql while inserting '\'

2002-02-15 Thread jroy
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