When I moved some of the previous code to another computer today,
Python manage.py syncdb
Time to report it.
(1366, "Incorrect string value: ' \\xE6\\x88\\x9A\\xE4\\xBC\\x9F ... '
Error, looked up, should be the database encoding setup problem, looked at the native database of the default encoding, sure enough
Mysql>Show variables like"%Char%";+--------------------------+--------------------------------------------------------+|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/Local/Mysql-5.7. One-osx10.9-x86_64/Share/Charsets/ |+--------------------------+--------------------------------------------------------+8Rowsinch Set(0.01sec) MySQL> SetCharacter_set_database='UTF8'; Query OK,0Rows affected,1Warning (0.00sec) MySQL> SetCharacter_set_server='UTF8'; Query OK,0Rows Affected (0.00Sec
It's okay to change those two latin1 codes to UTF8.
django-1366, "Incorrect string value: ' \\xE6\\x88\\x9A\\xE4\\xBC\\x9F ... '