#36 Export new lines correctly using data scripts

closed-accepted
nobody
plugin (16)
5
2010-10-13
2010-10-01
Paul Wagland
No

The current data export script changes embedded new line characters to '\n'. the problem with this is that SQL clients tend not to change '\n' back to NL characters, and so the script cannot be used to recreate the database.

For example, if you have a text field with the contents (between ----)
----
\n
newline
----
It gets exported as '\n\nnewline'. This is obviously incorrect, since there is also no way to convert the exported data back to the original, since there is no way to determine whether the '\n' should be converted back to '\n' or NL.

This patch fixes the data export.

Discussion

  • Paul Wagland
    Paul Wagland
    2010-10-01

    Patch to export new lines correctly

     
  • Gerd Wagner
    Gerd Wagner
    2010-10-13

    • status: open --> closed-accepted
     
  • Gerd Wagner
    Gerd Wagner
    2010-10-13

    Patch has been accepted in a extended way: SQL-Preferences now allow to
    choose the escape string