title: MySQL choking on curly (smart) quotes
body: <p>I'm inserting some data into a database from a form. I'm using <code>addslashes</code> to escape the text (have also tried <code>mysql_real_escape_string</code> with the same result).</p>
  
  <p>Regular quotes are escaped, but some other quotes are not. For example, the string:</p>
  
  <blockquote>
    <p>Homer's blood becomes the secret ingredient in Moe’s new beer.</p>
  </blockquote>
  
  <p>is converted to:</p>
  
  <blockquote>
    <p>Homer\'s blood becomes the secret ingredient in Moe’s new beer.</p>
  </blockquote>
  
  <p>I didn't think the curly quote would matter unescaped, but only this text is inserted into the database:</p>
  
  <blockquote>
    <p>Homer's blood becomes the secret ingredient in Moe</p>
  </blockquote>
  
  <p>So PHP thinks the curly quote is fine, but MySQL is losing the string. MySQL is not giving any errors though.</p>