title: How to insert emoji into MYSQL 5.5 and higher using Django ORM
body: <p>I am trying to insert emoji's  into a certain filed in my mysql table.
  I ran alter command and changed the collation to <strong>"utf8mb4_general_ci"</strong></p>
  
  <pre><code>  ALTER TABLE XYZ MODIFY description VARCHAR(250) CHARACTER SET utf8mb4
    COLLATE utf8mb4_general_ci;
  </code></pre>
  
  <p>Table details after above query:</p>
  
  <pre><code>+-------------+--------------+---------------+--------------------+
  | Column      | Type         | Character Set | Collation          |
  +-------------+--------------+---------------+--------------------+
  | description | varchar(250) | utf8mb4       | utf8mb4_general_ci |
  +-------------+--------------+---------------+--------------------+
  </code></pre>
  
  <p>After this I ran the query to update <strong>description</strong> column with emoji's, every time I ran below query, the emoji is replaced by '?'.</p>
  
  <pre><code>  update XYZ set description='a test with : ' where id = 1;
  </code></pre>
  
  <p>But when i print the result from a select query for the same id, it displays' '?' in place of emoji. The result was:</p>
  
  <pre><code>  "a test with : ??"
  </code></pre>
  
  <p>Carried out necessary changes into model file.
  <strong>Please accept my Apologies for not making it clear, would appreciate any lead in this matter.</strong></p>