This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma 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


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: 43949
    
  33
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: 43949
    
  33
You're welcome
 
Have you checked out Aspose?
 
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!