雅加达ee如何解决java中“字符串或二进制数据将被截断”的问题?
我为文件创建了一个表,我为文件varbinary(MAX)设置了数据类型,当我尝试上载文件时,它会显示:
String or binary data would be truncated
当我像这样编写insert查询时:
String sql = "INSERT INTO contacts (first_name, last_name, photo) values (?, ?, ?)";
PreparedStatement statement = conn.prepareStatement(sql);
statement.setString(1, firstName);
statement.setString(2, lastName);
if (inputStream != null) {
// fetches input stream of the upload file for the blob column
statement.setBlob(3, inputStream);
}
我也尝试过setBinaryStream,但它仍然给了我同样的错误,所以请帮助我如何解决它
# 1 楼答案
该错误意味着在}
VARBINARY(MAX)
列中保存数据时,二进制数据将被截断。只需将列的类型更改为^{