title: How to filter a column with Non-accented characters using select query
body: <p>I have a MySQL table (test) with utf-8 charset encoding. There are three entries, two entries with normal characters and another name with accent characters.</p>
  
  <pre><code>CREATE TABLE test (
    id Integer,
    name VARCHAR(50), 
    PRIMARY KEY (id)
  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
  
  INSERT INTO `test` (`id`, `name`) VALUES (1, 'aaaa');
  INSERT INTO `test` (`id`, `name`) VALUES (2, 'AAAA');
  INSERT INTO `test` (`id`, `name`) VALUES (3, 'áááá');
  </code></pre>
  
  <p>If I run the following select query, it returns all the 3 entries</p>
  
  <p><strong>Actual Result:-</strong></p>
  
  <pre><code>select * from test where name like '%aa%';
  
  id  | name
  ----|----
  1   | aaaa
  2   | AAAA
  3   | áááá
  </code></pre>
  
  <p>Instead of that, it should be return last entry with id=3.</p>
  
  <p>I don't want to use 'BINARY' OR 'COLLATE utf8_bin' because it returns only case sensitive search.</p>
  
  <p>I need normal search with string <strong>like</strong> query, e.g:-</p>
  
  <p><strong>Expected Result:-</strong></p>
  
  <pre><code>select * from test where name like '%aa%';
  
  id | name
  ---|-----
  1  | aaaa
  2  | AAAA
  </code></pre>