title: sqlite remove non utf-8 characters
body: <p>I have an sqlite db that has some crazy ascii characters in it and I would like to remove them, but I have no idea how to go about doing it.  I googled some stuff and found some people saying to use REGEXP with mysql, but that threw an error saying REGEXP wasn't recognized.</p>
  
  <p>Here is the error I get:</p>
  
  <pre><code>sqlalchemy.exc.OperationalError: (OperationalError) Could not decode to UTF-8 column 'table_name' with text ...
  </code></pre>
  
  <p>Thanks for the help</p>