title: Emoji is not stored properly in MySQL 5.6 with collation utf8mb4
body: <p>I am trying to store emoji to the database in my server. I am using AWS EC2 instance as server, my server details are listed below:</p>
  
  <blockquote>
    <p>OS: ubuntu0.14.04.1</p>
    
    <p>MySQL version: 5.6.19-0ubuntu0.14.04.1 - (Ubuntu)</p>
    
    <p>Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503</p>
  </blockquote>
  
  <p>I created a database test and table emoji in the server with following SQL:</p>
  
  <pre><code>CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  USE `test`;
  
  CREATE TABLE IF NOT EXISTS `emoji` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `text` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1;
  </code></pre>
  
  <p>When I tried to execute the following insert, a warning appears and data are not stored properly:</p>
  
  <pre><code>INSERT INTO  `test`.`emoji` (`id` , `text`) VALUES (NULL ,  '   ');
  </code></pre>
  
  <blockquote>
    <p>Inserted row id: 3</p>
    
    <p>Warning: #1366 Incorrect string value: '\xF0\x9F\x91\x86 \xF0...' for column 'text' at row 1</p>
  </blockquote>
  
  <p>The value stored in the text column is: <strong>???? ???? ???? ????</strong></p>
  
  <p>The same scenario work for my local database and the values are stored properly. Almost all configurations are similar in my local except the OS (Windows).</p>