django.db.utils.OperationalError: (1366, "Incorrect string value) django mysql - Apache

art_cs
July 28, 2020
92 views
1 vote
2 Answers

hi i created a django project and tried to deploy it on ubuntu apache server with mysql database

but when i run python3 manage.py migrate i get this error :

django.db.utils.OperationalError: (1366, "Incorrect string value: ‘xD9x88xDBx95xD8xB3…’ for column ‘name’ at row 1")

i have only one column named name = models.CharField(max_length=30)

when i run show variables like 'char%'; the output is :

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

and in my /etc/mysql/my.cnf i set [client] default-character-set = utf8
is there something i’ve missed ?!

Answers

- SachinYadav
- July 29, 2020 at 3:12 am
- 0 votes
0
The “utf8” encoding only supports three bytes per character so, you cannot store 4-byte characters in MySQL with the utf-8 character set.

For more info read this

1.Change your MySQL database, table and columns to use the utf8mb4 character set

2.In your settings.py
```
DATABASES = {
    'default': {
        'ENGINE':'django.db.backends.mysql',
        ...
        'OPTIONS': {'charset': 'utf8mb4'},
    }
}
```
Login or Signup to reply.