A while back I tried using apostrophes in titles and there were too many LLs who gave me error messages to bother keeping track.
It's such an easy fix in PHP. If you've got magicquotes turned off:
addslashes (before putting into DB)
stripslashes (after pulling out of DB)
htmlspecialchars (before putting into HTML form input tag)
and you're done.