Post

To store emojis in MariaDB/MySQL for an existing table using the default/bad collation: ALTER TABLE your_table_name CONVERT TO character set utf8mb4 collate utf8mb4_unicode_ci; In Django's settings .py: 'OPTIONS': { 'charset': 'utf8mb4', } NOTE: collation name and charset are slightly different.

I had changed my DB settings in django's settings to support emojis, but forgot I had already built some tables using the bad/default charset/collation... It's sometimes easier to change the DB (main) instead of using migrations, if it's just a table that snuck through w/out the right charset.