I've got a Perl DBI application that's working fine with
MySQL and PostgreSQL. Now I'm trying to add support for
CSV files using the DBD::CSV modules.
I've run into a problem with storing text that contains
embedded newslines or returns. With the real SQL DBs, I
just do something like dbh->quote("line 1 \n line 2")
and then insert it. When I retrieve the text and print
it, I get:
line 1
line 2
But with DBD::CSV, it seems to be converting each newline
newline character in the literal characters slash and n,
so that when I print the retrieved text, it looks like
this:
line 1 \n line 2
Do I need to do something special with regard to newlines
and returns when using DBD::CSV or does the quote function
not work with it? I suspect I'm missing something obvious
here...
-Steve
_____________________________________________________________________
R. Steven Rainwater * http://www.ncc.com/humans/srainwater/index.html
"As you struggle to save humanity be sure to avoid electrodes in
your path" -- Robotron 2084
