Inserting into a text field

[russ3ell]

Hi there

I'm using perl DBI and placeholders with a syntax like:
$dbh->do("INSERT INTO foo VALUES (?,?)",undef,@fields)
This loads up the data. However, one of my fields has newlines in it. When this is printed out the newlines are display as '\n' and not as new lines. Do I need to escape them or convert them from '\n' to '\r' or something else?

 

[russ3ell]

Idiot that I am, my problem was with extracting the data after. Using mysql, I didn't have the -r option set. Please close this thread - or possibly delete it