首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > Web前端 >

(1366, "Incorrect string value: '\\xE6\\xB7\\xB1\\xE5\\x85\\xA5.' for colum

2012-09-10 
(1366, Incorrect string value: \\xE6\\xB7\\xB1\\xE5\\x85\\xA5... for column [client]port3306[m

(1366, "Incorrect string value: '\\xE6\\xB7\\xB1\\xE5\\x85\\xA5...' for column '

[client]port=3306[mysql]default-character-set=gbk# SERVER SECTION# ----------------------------------## The following options will be read by the MySQL Server. Make sure that# you have installed the server correctly (see above) so it reads this # file.#[mysqld]# The TCP/IP Port the MySQL Server will listen onport=3306#Path to installation directory. All paths are usually resolved relative to this.basedir="D:/Program Files/MySQL/MySQL Server 5.1/"#Path to the database rootdatadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"# The default character set that will be used when a new schema or table is# created and no character set is defineddefault-character-set=gbk# The default storage engine that will be used when create new tables whendefault-storage-engine=INNODB


附注:

更新的数据中有中文,出现如下错误:
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

类似这样的错误,应该是数据库表的charset和collation问题。尝试把所有表的charset改为utf-8, collation改为utf8-unicode-ci。如果还是不能解决,最好是重建数据库,然后修改数据库的属性,选择charset为utf-8,collation为utf8-unicode-ci。命令行:create database cc default charset utf8 collate utf8_unicode_ci;
PS:我就是要重建数据库才解决。

热点排行