http://qs321.pair.com?node_id=731569


in reply to A puzzled garbage character issues by use Perl-DBI

I believe you have things backwards. In your first example, you want to use $dbh->quote(), because if you have single quotes in your content, you could run into some security vulnerabilities. In your second example, you do not need to quote because placeholders will automatically (and appropriately) quote any content. Try removing the call to quote and see if it makes a difference.