当前位置:Gxlcms > 数据库问题 > nested exception is java.sql.SQLException: 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

时间:2021-07-01 10:21:17 帮助过:44人阅读

技术分享

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   

人气教程排行