首页 > 数据库技术 > 详细

nested exception is java.sql.SQLException: Incorrect string value: '\xE7\x99\xBB\xE9\x99\x86...' for column 'image' at row 1

时间:2017-03-25 10:59:06      阅读:802      评论:0      收藏:0      [点我收藏+]

HTTP Status 500 - Hibernate operation: could not insert: [cn.itcast.shop.product.vo.Product]; uncategorized SQLException for SQL [insert into product (pname, market_price, shop_price, image, pdesc, is_hot, pdate, csid) values (?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1366]; Incorrect string value: ‘\xE7\x99\xBB\xE9\x99\x86...‘ for column ‘image‘ at row 1; nested exception is java.sql.SQLException: Incorrect string value: ‘\xE7\x99\xBB\xE9\x99\x86...‘ for column ‘image‘ at row 1

技术分享

image字段类型有问题

技术分享

修改字段类型:

mysql> alter table product modify image varchar(255) charset utf8 collate utf8_general_ci;
Query OK, 71 rows affected
Enregistrements: 71 Doublons: 0 Avertissements: 0

 

扩展:

修改字段名称:

mysql> alter table product change image images varchar(255);
Query OK, 0 rows affected
Enregistrements: 0 Doublons: 0 Avertissements: 0

 

nested exception is java.sql.SQLException: Incorrect string value: '\xE7\x99\xBB\xE9\x99\x86...' for column 'image' at row 1

原文:http://www.cnblogs.com/wangfeihu/p/6616013.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!