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)
DATABASES = {
'default': {
...,
# other settings
'OPTIONS':{
'charset': 'utf8mb4', # support emoji
}
}
}
""" DATABASES={
'default':{
'ENGINE' : 'django.db.backends.mysql',
'NAME' : 'your-db-name',
'USER' : 'user_name',
'PASSWORD' : 'your-db-password',
'HOST' : 'localhost',
'PORT' : '3306',
'OPTIONS' : {
'charset : 'utf8mb4',
}
} """
Comments
Kotlin Kya Hai?
Search Engine Kya Hai?
Aanha services are counted among the best website designing company in Delhi. This top-rated company can help you generate a powerful online presence that stands head and shoulders above your rivals by developing a highly functional website with all the relevant content and images. Digital Service helps in your business grow, brand, and influence audiences online through a website, blogs, video content, and social media. Know more visit us now.
1. Download the CopyCat Plugin from the Figma community page
2. Open CopyCat in Figma by right clicking on the design canvas, select plugins, and select CopyCat.
3. Sign up for an account by clicking 'Get Started' and login to CopyCat using your Figma account.
4. Input the file url.
5. Select the frame you want to convert by pointing your cursor on the frame and click the frame you want to generate code for. The code will be generated automatically.
6. Export the design to your dev environment after previewing and making necessary changes.
CopyCat is one tool that can help smoothen the design to developer handoff process, and it is constantly updating to improve the code generated so you can sit back, relax, and code the challenges you want.