Eexception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PIC' at
来源:互联网 发布:拉杆箱特卖淘宝 编辑:程序博客网 时间:2024/05/21 06:57
今天在测试往数据库存图像、读图像以及更新图像时,前面存和读都没问题,但是后面用一张新图new.jpg更新时就出现上面的异常,图像字段为img,BLOB类型。
Data truncation即字段过长,放不下。网上找了半天都是关于编码的。即中文字符一个字符占据的空间是一个英文字符的两倍,因此而导致放不下。但是我这个是图像的存取,存取的是Binary Stream(字节流),所以我怀疑可能是图像文件过大,一查果不其然。
old.jpg原图有55.6K,而new.jpg有92.3K。去查了下BLOB允许的最大值,如下:
MySQL的四种BLOB类型
类型 大小(单位:字节)TinyBlob 最大 255
Blob 最大 65K
MediumBlob 最大 16MLongBlob 最大 4G
显然92.3K超出了BLOB的最大范围。
- Eexception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PIC' at
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'name' at r
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column MenuGrpCode at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'sex' at row 1”
- ### Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column \'name\' at row 1
- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at ro
- 数据库编码com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'sex' at row 1
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' a
- ssh框架中的错误:com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'user_name'
- Mysql MysqlDataTruncation Data truncation Data too long for column
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'price'
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'rdate'
- java-mysql异常<Data truncation: Data too long for column 'name ' at row 1>讨论
- mysql 数据库 错误 Data truncation: Data too long for column 'name' at row 1
- (POJ)2140 Herd Sums
- HDU1061:Rightmost Digit
- 谈谈离职和跳槽
- 又一个无辜的故障排查
- 关于数据结构的思考
- Eexception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PIC' at
- java零碎要点---struts2中redirect和redirectAction的区别
- svn详细教程
- 图文详解如何搭建Windows的Android C++开发环境
- HIBERNATE的缓存机制
- dul恢复truncate表测试
- 第六周项目一(2)
- 清明节追溯祖先白圭
- 设计模式总结—单例模式