title: Emojis replaced by question marks when insert in Database
body: <p>I'm having an issue with emojis not being transferred correctly to my staging site. Some emojis are replaced by a question mark, some don't. It's mainly affecting the blog posts. I'm not sure what is causing this and was hoping someone could point me in the right direction to solving this problem! Could it be something with the character encoding in the database?</p>
  
  <p>For example:
  These work: ☀️ ☔️❤️✨
  These get replaced by a question mark: 
  and show this Error:</p>
  
  <pre><code>1366 Incorrect string value: '\xF0\x9F\x98\x83\xF0\x9F...' for column 'text' at row 1
  </code></pre>
  
  <p>MY SQL Code:</p>
  
  <pre><code>CREATE TABLE `posts` (
    `id` int(11) UNSIGNED NOT NULL,
    `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
    `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
    `timestamp` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  </code></pre>
  
  <p>Have run and tried this SQL Codes:</p>
  
  <pre><code>ALTER TABLE posts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
  
  ALTER DATABASE test CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
  </code></pre>