523 2007-04-30 12:21:00 +0100 Restoring from SQL does not escape newline character 2009-06-23 12:21:34 +0100 1 1 1 Unclassified Compendium ** General ** 1.5.2 PC Windows RESOLVED FIXED High Bug-Normal 2.0 Beta 1 1 dariusz.kaminski m.s.bachler jeff dariusz.kaminski 2007-04-30 12:21:41 +0100 After having backed up the content with nodes containing text with multiple lines (each made by pressing Enter) I restored the database from this SQL file. Instead of having the text with sentences starting in separate lines, I got them all like this: 'This is the first line.\nThis is the second line.\nThis is the third line.' It seems that newline characters are not escaped properly when the file is being restored to the project. This is how the SQL data looks like: INSERT INTO Node (NodeID, Author, CreationDate, ModificationDate, NodeType, OriginalID, ExtendedNodeType, Label, Detail, CurrentStatus, LastModAuthor) VALUES ('826936641177931332515','Dariusz Kaminski',1177931332515,1177931384265,10,'','','Testing what happens with new line \n and why it is not escaped','This is the first line.\nThis is the second line.\nThis is the third line.',0,'Dariusz Kaminski') I hope this helps. alselvin 2007-05-03 22:44:16 +0100 Thanks for reporting this. It's been a known issue in the past that I thought had been addressed but seems not. m.s.bachler 2007-05-11 09:30:27 +0100 Yes, I thought I had fixed this for 1.5.2. It was all working fine. I'll do some testing. m.s.bachler 2007-08-08 10:20:01 +0100 *** Bug 530 has been marked as a duplicate of this bug. *** m.s.bachler 2009-06-23 12:21:34 +0100 OK. I think I have cracked it this time :-)