MySQL Bugs: #1137: Problem inserting '\' on a LongText Field

Bug #1137	Problem inserting '\' on a LongText Field
Submitted:	26 Aug 2003 2:09	Modified:	26 Aug 2003 8:40
Reporter:	David Sancho	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.14	OS:	Windows (Win2000)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
All \ in the text are lost, and \\ are converted to \.

How to repeat:
CREATE TABLE `launchdata` (
  `IdLaunch` int(11) NOT NULL default '0',
  `DataMessage` longtext NOT NULL,
  `DataType` tinyint(4) NOT NULL default '0',
  KEY `IdLaunch` (`IdLaunch`)
) TYPE=InnoDB;

INSERT INTO LaunchData (DataMessage,DataType,IdLaunch) VALUES ('http:\\iblnews.com  this \ is alone', 0, 1)

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php