This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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


Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 44449
    
  34
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: 44449
    
  34
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...
 
It's not a secret anymore!