About Emoji Support with MySQL

If you want to support all Unicode characters including emojis in MySQL database, you have to use utf8mb4 encoding instead of utf8.

To create a MySQL database with full Unicode support run SQL query:

CREATE DATABASE mydatabase 
CHARACTER SET utf8mb4 
COLLATE utf8mb4_unicode_ci;

But there is a catch. If you use utf8mb4 encoding, the indexed fields can have the maximum length of 191 characters, e.g.:

class Bookmark(models.Model):
    url = models.UrlField(_("URL"), max_length=191, db_index=True)

For Django-based SaaS projects.

Django App for You

For Django websites that use cookies.

Django App for You

Learn how to build practical web projects with Django 3.

It's not for everyone, but it might be for you!