输入banner图图片脚本导航/分类

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

标签:nat   nts   images   reg   exce   value   hiberna   0 rows   sid