title: Bad MySQL import, now we have garbage showing in place of utf-8 chars
body: <p>We restored from a backup in a different format to a new MySQL structure (which is setup correctly for UTF-8 support). We have weird characters showing in the browser, but we're not sure what they're called so we can find a master list of what they translate to.</p>
  
  <p>I have noticed that they do, in fact, correlate to a specific character. For example:</p>
  
  <pre><code>â„¢ always translates to ™
  â€” always translates to —
  â€¢ always translates to ·
  </code></pre>
  
  <p>I referenced this post, which got me started, but this is far from a complete list. Either I'm not searching for the correct name, or the "master list" of these bad-to-good conversions as a reference doesn't exist.</p>
  
  <p>Reference:
  <a href="https://stackoverflow.com/questions/1476356/detecting-utf8-broken-characters-in-mysql">Detecting utf8 broken characters in MySQL</a></p>
  
  <p>Also, when trying to search via MySQL query, if I search for â, I always get MySQL treating it as an "a". Is there any way to tweak my MySQL queries so that they are more literal searches? We don't use internationalization much so I can safely assume any fields containing the â character is considered to be a problematic entry, which would need to be remedied by our "fixit" script we're building.</p>