title: MySQL DISTINCT and accents
body: <p>A MySQL database running on Debian (version 5.5.41-0+wheezy1-log).</p>
  
  <p>A table <code>hotels</code> with a column <code>name VARCHAR(128)</code> and engine is InnoDB.</p>
  
  <pre><code>CREATE TABLE `hotels` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT
    `name` varchar(128) NOT NULL DEFAULT '' COMMENT 'Hotel Name',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>There are two records in this table:</p>
  
  <pre><code>1    BEST WESTERN PREMIER LE CARRE FOLIES OPERA
  2    BEST WESTERN PREMIER LE CARRÉ FOLIES OPÉRA
  </code></pre>
  
  <p>When executing <code>select DISTINCT name FROM hotels</code>, the query is returning only 1 record, while 2 records were expected to be returned.</p>
  
  <p>The DBMS doesn't seem to distinct between E and É.</p>
  
  <p>How to change the table settings in order to get the expected result?</p>