in reply to Escaping characters

  1. Show us the code
  2. Show us the error

:-)

My complete guess is that you're doing something like:

$dbh->do("update ... title = '$title'");

In which case your extra apostrophie in the title is producing an illegal SQL statement.

If this is what you're doing you want to look at 'Placeholders and Bind Values' in the DBI documentation for the right way to do it.