#36 Export new lines correctly using data scripts

closed-accepted
nobody
plugin (16)
5
2010-10-13
2010-10-01
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

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks