id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc
56,Newlines get unescaped on their way to the database.,schuler.steffen,scott,"As reported by steffen schuler:

  [[BR]]   If one pastes code with the literal !``\n!'' inside the code or[[BR]]   in the header, then the pasted output is different.

=== Reproduction Steps ===
 1. Navigate to http://awkpaste.blisted.org/
 1. Enter the following paste:
{{{
# An escaped linefeed
print ""\n""

# An escaped escape and an n.
print ""\\\n""

# An escaped carriage return
print ""\r""

# An escaped esacpe and an r.
print ""\\r""

# escaped escape
print ""\\""

# End of line that's escaped.
print ""This string is waaaaaaay too large for me to possibly be able "" \
      ""to fit it in a single line""

# Some accidental backslashes: \\
# Four backslashes and an n: \\\\n
}}}
 1. Observe output.
 1. Click paste-id link at top left corner of page.

=== Expected ===
The paste output from the paste-id link is the same as that returned by the form submission.

=== Observed ===
The text `\n` is translated into a newline in the paste output.

Additionally, the contents of the database are:

{{{
mysql> select content from paste where paste_id = '567';
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| content                                                                                                                                                                                                                                                                                                                                                                                                       |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| # An escaped linefeed
print ""\n""

# An escaped escape and an n.
print ""\\n""

# An escaped carriage return
print ""\r""

# An escaped esacpe and an r.
print ""\\r""

# escaped escape
print ""\\""

# End of line that's escaped.
print ""This string is waaaaaaay too large for me to possibly be able "" \
      ""to fit it in a single line""

# Some accidental backslashes: \\
# Four backslashes and an n: \\\\n | 
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
}}}
The database content suggests the issue is most likely in the mysql library escaping content coming'' from'' the database.",defect,closed,critical,awkpaste,awkbot,1.0,fixed,,