title: unable to store utf8mb4 in mysql
body: <p>I'm using django with mysql. I want to change my unicode utf8 to utf8mb4 for storing emojis. i did try and  change some fields. here is the variables-</p>
  <pre><code>mysql&gt; SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 
   'collation%';
  +--------------------------+--------------------+
  | Variable_name            | Value              |
  +--------------------------+--------------------+
  | character_set_client     | utf8mb4            |
  | character_set_connection | utf8mb4            |
  | character_set_database   | utf8mb4            |
  | character_set_filesystem | binary             |
  | character_set_results    | utf8mb4            |
  | character_set_server     | utf8               |
  | character_set_server     | utf8               |
  | character_set_system     | utf8               |
  | collation_connection     | utf8mb4_general_ci |
  | collation_database       | utf8mb4_unicode_ci |
  | collation_server         | utf8_general_ci    |
  +--------------------------+--------------------+
  10 rows in set (0.00 sec)
  </code></pre>
  <p>Right now when i'm trying to add an emoji its prints <strong>?</strong> question mark.
  I also change my databse and my.cnf file-</p>
  <pre><code>DATABASES = {
      ’default’: {
          ’ENGINE’: ’django.db.backends.mysql’,
          ’NAME’: ’example’,
          ’USER’: ’example’,
          ’PASSWORD’: ’example’,
          ’HOST’: ’’,
          ’PORT’: ’’,
          ’OPTIONS’: {’charset’: ’utf8mb4’},
      }
  }
  </code></pre>
  <p>and my.cnf-</p>
  <pre><code>[client]
  default-character-set = utf8mb4
  
  [mysql]
  default-character-set = utf8mb4
  
  [mysqld]
  character-set-client-handshake = FALSE
  character-set-server = utf8mb4
  collation-server = utf8mb4_unicode_ci
  </code></pre>
  <p>somehow the collation server is still shows the utf8 encode and collation connection shows utf8mb4_general_ci</p>