my $dbh  = DBI->connect( ... );
my $text = "aaaaa\nbbbb";
my $sql  = $dbh->quote($text);

##</code><code>##

my $sth = $dbh->prepare('insert into test(field1) values(?)');
$sth->execute($text);