title: Why the same sql got the diff result
body: <p>Why the same sql got the different result? See below:</p>
  
  <pre><code>CREATE TABLE `t` (
  `data` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1
  mysql&gt; insert into t select '\U+1F600' ;
  Query OK, 1 row affected (0.00 sec)
  mysql&gt; select * from t;
  +------+
  | data |
  +------+
  |      |
  +------+
  mysql&gt; insert into t select '\U+1F600' ;
  mysql&gt; select * from t;
  +---------+
  | data    |
  +---------+
  |         | 
  | U+1F600 |
  +---------+
  </code></pre>
  
  <p>The data content of first insert sql copied from website(<a href="http://getemoji.com/" rel="nofollow">http://getemoji.com/</a>), the second sql just copy the first sql in current terminal. So what is the diff between these two sql? Is there some method I could use to show the diff explicitly? Thanks!  </p>