Django manager migrate：django.db.utils.OperationalError: (1366, “Incorrect string value: ‘\\xE6\\x85\\xA2\\xE6\\x97\\xA5…’ for column ‘name’ at row 1”)
具体报错如下：
发生这个问题的原因是因为：MySQL的数据库的字符集的问题
解决方法：MySQL的字符集，需要设置为：utf8 / utf8mb4
具体如下：
注意，其中参数【character_set_server = utf8】
然后，再次执行Django manage.p[……]
- Posted on:
-
Author:
Adamhuan
- Categories: Django
- Tags: __init__.py, -, -p, ，, :, ", /, /etc/my.cnf, 1.8, 10, 11, 12, 16, 18, 2, 200, 2015, 2016, 2017, 206, 22, 26, 3, 3.6, 30, 4, 5, 5.7, 50, 6, 64, 7, 8, 8.0, 80, 9, active, add, admin, alias, ant, auto, b, backup, bat, bc, binary, cal, cat, change, character, cmd, command, config, create, datadir, date, db, dd, default, Django, dm, else, error, except, exception, exit, fetch, File, find, for, form, from, gem, go, group, group_name, http, imp, init, innodb, insert, js, last, list, log, main, make, makemigrations, man, manage.py, messages, migrate, model, module, mount, my.cnf, MySQL, mysqld, No changes detected, ogg, options, package, pid, post, pre, ps, put, python3, rap, remove, repo, report, rm, root, s, size, sock, socket, sort, SQL, sys.argv, tr, try, ui, use, user, valid, war, win, 参数, 字符, 字符集, 库, 执行, 报错, 数据, 数据库, 解决, 解决方法, 设置, 错, 问题
- Leave a comment: Django manager migrate：django.db.utils.OperationalError: (1366, “Incorrect string value: ‘\\xE6\\x85\\xA2\\xE6\\x97\\xA5…’ for column ‘name’ at row 1”)