title: google CloudSQL mysql emoji (1366, "Incorrect string value: '\\xF0\\x9F\\x98\\x80\\xF0\\x9F...' for column 'name' at row 1")
body: <p>I can't make it to post emojis to the database when I use my-app.appspot.com
  but when I run it locally <code>python manage.py runserver</code>with the same libraries on GAE everything works perfectly and I can post and retrieve emojis .</p>
  
  <p>here is my settings .py</p>
  
  <pre><code>import os
  if os.getenv('SERVER_SOFTWARE', '').startswith('Google App Engine'):
      # Running on production App Engine, so use a Google Cloud SQL database.
      DATABASES = {
          'default': {
              'ENGINE': 'django.db.backends.mysql',
              'HOST': '/cloudsql/my-app:us-central1:my-app-mysql',
              'NAME': '********',
              'USER': 'root',
              'PASSWORD': '*********',
          }
      }
  else:
      DATABASES = {
          'default': {
              'ENGINE': 'django.db.backends.mysql',
              'NAME': '*******',
              'USER': 'root',
              'PASSWORD': '*********',
              'HOST': '**********',
              'PORT': '3306',
              'OPTIONS': {
                   'charset': 'utf8mb4',
              }
          }
      }
  </code></pre>
  
  <p>here is the charset when using cloud shell</p>
  
  <pre><code>mysql&gt; SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
  +--------------------------+--------------------+
  | Variable_name            | Value              |
  +--------------------------+--------------------+
  | character_set_client     | utf8               |
  | character_set_connection | utf8               |
  | character_set_database   | utf8mb4            |
  | character_set_filesystem | binary             |
  | character_set_results    | utf8               |
  | character_set_server     | utf8mb4            |
  | character_set_system     | utf8               |
  | collation_connection     | utf8_general_ci    |
  | collation_database       | utf8mb4_general_ci |
  | collation_server         | utf8mb4_general_ci |
  +--------------------------+--------------------+
  10 rows in set (0.15 sec)
  </code></pre>
  
  <p>and here is the charset when I connect using the IP of the database from another client</p>
  
  <pre><code>Variable_name                        Value
  character_set_client                utf8
  character_set_connection            utf8mb4
  character_set_database              utf8mb4
  character_set_filesystem            binary
  character_set_results               utf8
  character_set_server                utf8mb4
  character_set_system                utf8
  collation_connection                utf8mb4_unicode_ci
  collation_database                  utf8mb4_general_ci
  collation_server                    utf8mb4_general_ci
  </code></pre>
  
  <p>I'm I missing something ?!!</p>
  
  <p>how do I make work? </p>
  
  <p>thanks
  <a href="https://github.com/GoogleCloudPlatform/appengine-django-skeleton/issues/28" rel="nofollow noreferrer">https://github.com/GoogleCloudPlatform/appengine-django-skeleton/issues/28</a></p>