Data truncation: Data too long for column 'logo' at row 1

java, jdbc, mysql

Solution

You are trying to insert data that is larger than allowed for the column `logo`.

Use following data types as per your need

TINYBLOB   :     maximum length of 255 bytes  
BLOB       :     maximum length of 65,535 bytes  
MEDIUMBLOB :     maximum length of 16,777,215 bytes  
LONGBLOB   :     maximum length of 4,294,967,295 bytes

Use `LONGBLOB` to avoid this exception.

Problem

I am trying to insert a photo into a BLOB column of a MySQL table, and I get an exception: ``` Data too long for column 'logo' at row 1. ``` Here is the JDBC: ``` int idRestaurant = 42; String restoname= "test"; String restostatus= "test"; InputStream fileContent = getUploadedFile(); int fileSize = getUploadedFileSize(); Class.forName("com.mysql.jdbc.Driver"); try (Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/resto" , "root" , "" )) { PreparedStatement ps = conn.prepareStatement("insert into restaurants (idRestaurant, restaurantName, status, logo) values(?,?,?,?)"); ps.setInt(1, idRestaurant); ps.setString(2, restoname); ps.setString(3, restostatus); ps.setBinaryStream(4, fileContent, fileSize); ps.executeUpdate(); conn.commit(); } ``` How do I solve this problem?

Original source