title: Character with encoding UTF8 has no equivalent in WIN1252
body: <p>I am getting the following exception:</p>
  
  <pre><code>Caused by: org.postgresql.util.PSQLException: ERROR: character 0xefbfbd of encoding "UTF8" has no equivalent in "WIN1252"
  </code></pre>
  
  <p>Is there a way to eradicate such characters, either via SQL or programmatically? <br />
  (SQL solution should be preferred).</p>
  
  <p>I was thinking of connecting to the DB using WIN1252, but it will give the same problem.</p>