title: Replace NonASCII Characters in MYSQL
body: <p>To convert NON ASCII Characters to ASCII I used the below query</p>
  
  <pre><code>UPDATE tablename
  SET columnToCheck = CONVERT(columnToCheck USING ASCII)
   WHERE columnToCheck &lt;&gt; CONVERT(columnToCheck USING ASCII)
  </code></pre>
  
  <p>It replaces the NON ASCII characters into replacement characters. But is it possible to replace those Non Ascii characters to SPACES. </p>
  
  <p>I tried some options, but its not working. Any suggestion.</p>