title: Replace non UTF-8 from String
body: <p>I have a table that has strings with non UTF-8 characters, like <code>�</code>. I need to change them in order they have back all accents, and other latin characters, like: <code>cap� to capó</code>. The field is a VARCHAR.</p>
  
  <p>So far, I have tried:<code>SELECT "Column Name", regexp_replace("Column Name", '[^\w]+','') FROM table</code></p>
  
  <p>And:
  <code>CONVERT("Column Name", 'UTF8', 'LATIN1')</code> but don't work at all.</p>
  
  <p>For instance, the error I get is: "Regexp encountered an invalid UTF-8 character (...)"</p>
  
  <p>I have seen other solutions, but I can't go on them because I cannot change the table because I am not administrator.</p>
  
  <p>Is there any whay to achieve this?</p>