$some_content = $dbh->quote('so long Asia character (maybe it contain single quotation)'); $sth = $dbh->prepare("insert into test_table(field) values (?)"); $sth->execute($some_content); $sth->finish();