title: How to store Emoji Character in MySQL Database
body: <p>I have a MySQL database configured with the default collation <code>utf8mb4_general_ci</code>. When I try to insert a row containing an emoji character in the text using the following query</p>
  <pre class="lang-sql prettyprint-override"><code>insert into tablename 
  (column1,column2,column3,column4,column5,column6,column7) 
  values 
  ('273','3','Hdhdhdhhzhzhzzhjzj 我爱你 ❌',49,1,'2016-09-13 08:02:29','2016-09-13 08:02:29');
  </code></pre>
  <p>MySQL is raising the following error</p>
  <blockquote>
  <p>1366 Incorrect string value: '\xF0\x9F\x98\x83\xF0\x9F...' for column
  'comment' at row 1</p>
  </blockquote>