com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
来源:互联网 发布:od软件 编辑:程序博客网 时间:2024/06/04 19:20
具体信息如下:
Exception in thread "main" com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'note' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2868)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at MyPrepare.main(MyPrepare.java:87)
第一,方法重载问题
第二,字符超过了长度
第三,就是编码问题(重要,容易被人忽略)
有两种可能,第一种就是数据库编码,另外一种数据库编码没问题,文件编码有问题
- com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
- com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorr
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value:
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- 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
- Exception in thread "main" com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too lo
- Eexception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PIC' at
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' a
- 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
- struts拦截器和action
- iOS FMDB自己封装的单例类
- verify return value
- iOS AFN进行断点下载
- iOS masonry进行页面适配
- com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
- iOS M3U8视频的下载与播放
- 新建SVN仓库设置
- iOS coredata的使用及版本升级
- 活动指示器ActivityIndicatorView和进度条ProgressView
- iOS block传值
- 建枚举类时出现“Project '**' is not a J2SE 5.0 compliant project.”问题怎么办?
- iOS 百度地图
- 线段树 csu1555 Inversion Sequence