Question

向数据库中插入数据，出现错误，这是那个错误日志，有没有大神解释一下原因是什么

Error occured at:2016-01-01 14:08:40
Line no.:201
Error Code: 1366 - Incorrect string value: '\xA8D\xA8D\xBE\xDD...' for column 'MerDesc' at row 10
Query:
CREATE TABLE leaveword (
ID int(4) NOT NULL auto_increment,
Member int(4) NOT NULL,
Admin int(4) default NULL,
Title char(60) default NULL,
/*
MySQL Data Transfer
Source Host: localhost
Source Database: db_eshop
Target Host: localhost
Target Database: db_eshop
Date: 2009-4-26 23:31:01
*/
SET FOREIGN_KEY_CHECKS=0
Error occured at:2016-01-01 14:09:06
Line no.:60
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET FOREIGN_KEY_CHECKS=0' at line 14

Query:
INSERT INTO `merchandise` VALUES ('1', '1', 'JavaScript 高级程序设计', '45.00', '34.00', 'c1', '', 'JavaScript是目前Web客户端开发的主要编程语言，也是Ajax的核心技术之一。本书从最早期Netscape浏览器中的JavaScript开始讲起，直到当前它对XML和Web服务的具体支持，内容主要涉及JavaScript的语言特点、JavaScript与浏览器的交互、更高级的JavaScript技巧，以及与在Web应用程序中部署JavaScript解决方案有关的问题，如错误处理、调试、安全性、优化/混淆化、XML和Web服务，最后介绍应用所有这些知识来创建动态用户界面。', '人民邮电出版社', '2009-04-21 00:00:00', '1')
Error occured at:2016-01-01 14:09:07
Line no.:201
Error Code: 1366 - Incorrect string value: '\xA8D\xA8D\xBE\xDD...' for column 'MerDesc' at row 10

Answer 1

插入前编一下码。encode成和创建数据库时的编码一样