aspose file tools*
The moose likes JDBC and the fly likes Couldn't able to insert image file in MySQL, Data truncation: Data too long for column 'image' at... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Couldn Watch "Couldn New topic
Author

Couldn't able to insert image file in MySQL, Data truncation: Data too long for column 'image' at...

Venkattesh Iyer
Greenhorn

Joined: Jun 15, 2008
Posts: 6
Hello friends,

I dont know what to do, i am tring to insert the image (blob) in to the table but I am getting such error
Data truncation: Data too long for column 'image' at row 1

Here is the code.




Please guide me,


Thanks,

Venkat.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39832
    
  28
Don't know, but what size image are you passing and what size BLOB did you specify?
Venkattesh Iyer
Greenhorn

Joined: Jun 15, 2008
Posts: 6
Ya the size of the file was more than tha size of BLOB.
I could solve by using LONGBLOB

Thanks, Venkat
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39832
    
  28
You're welcome
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Couldn't able to insert image file in MySQL, Data truncation: Data too long for column 'image' at...