title: Removing strange characters from MySQL data
body: <p>Somewhere along the way, between all the imports and exports I have done, a lot of the text on a blog I run is full of weird accented A characters.</p>
  <p>When I export the data using mysqldump and load it into a text editor with the intention of using search-and-replace to clear out the bad characters, searching just matches every &quot;a&quot; character.</p>
  <p>Does anyone know any way I can successfully hunt down these characters and get rid of them, either directly in MySQL or by using mysqldump and then reimporting the content?</p>