title: Handling 'incorrect string values'
body: <p>I'm scraping the text from websites and putting it in a database, but one website's text keeps giving me this error when I try to do the database insertion:</p>
  
  <pre><code>Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: '\xC2\x80\xC2\x99 s...' for column 'text' at row 1
  </code></pre>
  
  <p>I think this has something to do with character encoding. Is there a function in javascript I can use to simply ignore these incorrect values? It's not critically important that the saved text matches the original perfectly. Alternatively, is there some mysql configuration I can do to support these characters? </p>