... my $info = $query->param('info'); $info =~ s/\n/

/g; my $sql = sprintf "insert into test values(%s)", $dbh->quote($info); $dbh->do($sql) || die; ...