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:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.14 OS:Microsoft Windows (Win2000)
Assigned to: CPU Architecture:Any

[26 Aug 2003 2:09] David Sancho
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)
[26 Aug 2003 8:40] Alexander Keremidarski
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