title: ERROR 1366 (HY000): Incorrect string value: '\xF0\x9F\x98\x9C' for column 'comment' at row 1
body: <p>Here's my sql:</p>
  
  <pre><code>INSERT INTO comments (createdate,userid,profileid,comment,status) 
  VALUES (1449503167,65704,65704,'@Mr_S66 Wish I was There For The Xmas Party I Miss My Studio 66 Family ðŸ˜œ',15)
  </code></pre>
  
  <p>Here's my comments schema:</p>
  
  <pre><code>    +------------+---------------+------+-----+---------+----------------+
      | Field      | Type          | Null | Key | Default | Extra          |
      +------------+---------------+------+-----+---------+----------------+
      | commentid  | int(11)       | NO   | PRI | NULL    | auto_increment |
      | parentid   | int(11)       | YES  |     | 0       |                |
      | refno      | int(11)       | YES  |     | 0       |                |
      | createdate | int(11)       | YES  |     | 0       |                |
      | remoteip   | varchar(80)   | YES  |     |         |                |
      | locid      | int(11)       | YES  | MUL | 0       |                |
      | clubid     | int(11)       | YES  |     | 0       |                |
      | profileid  | int(11)       | YES  | MUL | 0       |                |
      | userid     | int(11)       | YES  | MUL | 0       |                |
      | legacyuser | int(11)       | YES  | MUL | 0       |                |
      | mediaid    | int(11)       | YES  |     | 0       |                |
      | status     | int(11)       | YES  |     | 1       |                |
      | comment    | varchar(4000) | YES  |     |         |                |
      | likes      | int(11)       | YES  |     | 0       |                |
      | dislikes   | int(11)       | YES  |     | 0       |                |
      | import     | int(11)       | YES  |     | 0       |                |
      | author     | varchar(50)   | YES  |     |         |                |
      +------------+---------------+------+-----+---------+----------------+
  </code></pre>
  
  <p>Heres my output of the <code>sql query</code>:</p>
  
  <blockquote>
    <p>ERROR 1366 (HY000): Incorrect string value: '\xF0\x9F\x98\x9C' for column 'comment' at row 1</p>
  </blockquote>
  
  <p>Not quite sure how to solve this yet. Possibly filter the comment text <code>using php</code> to accommodate the string value. </p>