|
MySQL版本5.0,tomcat版本5.5;
MySQL中使用SHOW VARIABLES命令,获得的相关字符编码:
| character_set_client | utf8
| character_set_connection | utf8
| character_set_database | gb2312
| character_set_filesystem | binary
| character_set_results | utf8
| character_set_server | utf8
| character_set_system | utf8
JSP网页编码一律为gb2312;
log4j显示的日志 :
2009-02-26 21:46:23,739 DEBUG com.sung.run.ProductBase method:com.sung.run.ProductBase.insert(ProductBase.java:123)
Syntax error or access violation, message from server: "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 ''测' at line 1"
相对应的语句:
insert into product(cid,brand,name,code,specification,series,keywords,amount,click,alive,storePrice,marketPrice,remark,description,imgB,
imgS,postDate) values('','','测','','','2','',0,0,0,23.0,0.0,'','','','','2009-02-26')
检查了近一天,实在是不知道哪出了问题,求助! |
|