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 have to use '\\'. However, the question remains that why should I give a special treatment to a String containing '\' ? Normally I am not bothered by the values I insert, as long as it is a String. I think I should be able to insert any String, irrespective of its value, into an attribute specified as VARCHAR, without any special treatment. What do you say about this, and is there any justification for this kind of behaviour ? Thanks and regards, Jit Roy Chowdhury Hughes Software Systems Gurgaon, India "DISCLAIMER: This message is proprietary to Hughes Software Systems Limited (HSS) and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. HSS accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus." --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php