$some_content = 'so long Asian character (maybe it contain single quotation)';
$sql = "insert into test_table(field) values ($dbh->quote($some_content))";
$dbh->do($sql); # you know, this works.