?????更新的數(shù)據(jù)中有中文,出現(xiàn)如下錯(cuò)誤:
OperationalError at /admin/blog/post/add/
(1366, "Incorrect string value: '\xE6\xB7\xB1\xE5\x85\xA5...' for column 'title' at row 1")
Request Method: POST
Request URL: http://localhost:8000/admin/blog/post/add/
Exception Type: OperationalError
Exception Value:
(1366, "Incorrect string value: '\xE6\xB7\xB1\xE5\x85\xA5...' for column 'title' at row 1")
Exception Location: C:\Python25\Lib\site-packages\MySQLdb\connections.py in defaulterrorhandler, line 35
???????類(lèi)似這樣的錯(cuò)誤负芋,應(yīng)該是數(shù)據(jù)庫(kù)表的charset和collation問(wèn)題。嘗試把所有表的charset改為utf-8, collation改為utf8-unicode-ci间护。如果還是不能解決歉胶,最好是重建數(shù)據(jù)庫(kù)献联,然后修改數(shù)據(jù)庫(kù)的屬性茴恰,選擇charset為utf-8,collation為utf8-unicode-ci颠焦。
命令行:
create database news default charset utf8 collate utf8_unicode_ci;