title: Incorrect string value: '\xF0\x9F\x8E\xB6\xF0\x9F...' MySQL
body: <p>I am trying to store a tweet in my MYSQL table.  The <a href="https://twitter.com/wendygomezz_/status/408709587735310337">tweet</a> is:</p>
  
  <blockquote>
    <p>quiero que me escuches, no te burles no te rias, anoche tuve un sueño que te fuiste de mi vida &#x1f3b6;&#x1f3b6;</p>
  </blockquote>
  
  <p>The final two characters are both <a href="http://www.fileformat.info/info/unicode/char/1f3b6/">'MULTIPLE MUSICAL NOTES' (U+1F3B6)</a>, for which the UTF-8 encoding is <code>0xf09f8eb6</code>.</p>
  
  <p>The <code>tweet_text</code> field in my table is encoded in <code>utf8mb4</code>.  But when I try to store the tweet in that column I get the following error message:</p>
  
  <blockquote>
    <p>Incorrect string value: '\xF0\x9F\x8E\xB6\xF0\x9F...'  for column 'tweet_text' at row 1.</p>
  </blockquote>
  
  <p>What is going wrong?  How can I fix this?  I need to store multiple languages as well and this character set works for all languages but not for the special characters like emoticons and emojis.</p>
  
  <p>This is my create table statement:</p>
  
  <pre><code>CREATE TABLE `twitter_status_data` (
    `unique_status_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `metadata_result_type` text CHARACTER SET utf8,
    `created_at` text CHARACTER SET utf8 NOT NULL COMMENT 'UTC time when this Tweet was    created.',
    `id` bigint(20) unsigned NOT NULL COMMENT 'Unique tweet identifier',
    `id_str` text CHARACTER SET utf8 NOT NULL,
    `tweet_text` text COMMENT 'Actual UTF-8 text',
    `user_id_str` text CHARACTER SET utf8,
    `user_name` text COMMENT 'User''s name',
    `user_screen_name` text COMMENT 'Twitter handle',
    `coordinates` text CHARACTER SET utf8,
    PRIMARY KEY (`unique_status_id`),
    KEY `user_id_index` (`user_id`),
    FULLTEXT KEY `tweet_text_index` (`tweet_text`)
  ) ENGINE=InnoDB AUTO_INCREMENT=82451 DEFAULT CHARSET=utf8mb4;
  </code></pre>