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
