title: Is MySQL converting UTF-8 characters in my query (not the results), stripping accents?
body: <p>I've some records in a DB where one of the VARCHAR fields may contain accented letters. If I do the following query using the CLI MySQL client I get 1 row returned, which is correct:</p>
  
  <pre><code>SELECT site_id, site_name FROM tbl_site WHERE site_name LIKE '%ém%'
  </code></pre>
  
  <p>However, using some PHP (PDO) to do the same query returns all the rows that contain 'em', but not the one row that contains 'ém'. Even more strangely, MySQL query logging shows that the query contains 'é', not 'e'.</p>
  
  <p>Any ideas what might be going on here?</p>