How to store emoji expressions in django mysql | Solve the problem of failure to store emoji expressions in django

# Common problem

The error information of storing emoji expressions in table intelligence in django + mysql is:

In Django, django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xF0\\x9F\\x90\\xA6 \\xF0...' for column 'description' at row 1").

# Reason

UTF-8 encoding may be two, three, or four bytes, Emoji expressions are 4-bytes, and MySql utf8 encoding is up to 3-bytes, so the data can't be inserted.

# Solution :

Convert Mysql encoding from utf8 to utf8mb4. The detailed description is as follow steps:

# Settings in MySql:

Step 1 : Modify the character set of the database:

• ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

Step 2 : Use the database that currently needs character set modification:

• use database_name;

Step 3 : Modify the character set of the table:

• ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Step 4 : Modify the character set of the column:

• ALTER TABLE table_name CHANGE field_name  VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

# Settings in django:

Step 5 : And finally, modify the code in settings.py as follows:

 ➤ Code: settings.py (MySql)

1. DATABASES={

2.   'default':{

3. ...,//other settings

4. 'OPTIONS':{

5.   'charset': 'utf8mb4', #support emoji

6. }

7. }

8.   

9. """ DATABASES={

10.   'default':{

11. 'ENGINE' : 'django.db.backends.mysql',

12. 'NAME' : 'your-db-name',

13. 'USER' : 'user_name',

14. 'PASSWORD' : 'your-db-password',

15. 'HOST' : 'localhost',

16. 'PORT' : '3306',

17. 'OPTIONS' : {

18.   'charset : 'utf8mb4',

19. }

20. } """