in reply to Text::CSV_XS and MySQL newline handling

Ugly, but what if your SQL was: "LINES TERMINATED BY '\\n'", then the extra escape backslash will cancel out the extra backslash in the terminator. Two wrongs make a right?

update I need coffee, sorry the terminating newlines are not the ones the escape works on. Any chance a different escape would work for you?

  • Comment on Re: Text::CSV_XS and MySQL newline handling

Replies are listed 'Best First'.
Re^2: Text::CSV_XS and MySQL newline handling
by perrin (Chancellor) on Nov 17, 2005 at 21:42 UTC
    I don't think that will help. Text::CSV_XS specifically wants some special characters escaped (e.g. ") but not newline. The problem is that they don't agree on what characters should be escaped.
[reply]

In Section Seekers of Perl Wisdom