in reply to Re^2: Line separators when passing multi-line fields to a database
in thread Line separators when passing multi-line fields to a database

You need to tell Perl to interpolate the string; double quotes should do it. The database engine will receive a string containing a literal beeline character.
  • Comment on Re^3: Line separators when passing multi-line fields to a database

Replies are listed 'Best First'.
Re^4: Line separators when passing multi-line fields to a database
by davies (Monsignor) on Mar 21, 2011 at 14:43 UTC

    I'm afraid I don't understand. I don't know what a "literal beeline" character is - Google doesn't help, so any references would be appreciated. The other problem is that I'm trying to prevent Perl changing the \n to \\n or anything else, so I'm not clear on what string I should be getting Perl to interpolate.

    Regards,

    John Davies

      Blasted auto-correction mode ... changed "newline" to "beeline." Remember that character strings in single quotes are not interpolated; character strings in double quotes, are.