Enter your email address:

Delivered by FeedBurner


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Exception:com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for colu
12-12-2011, 09:39 PM (This post was last modified: 12-18-2011 10:09 PM by rajasri.)
Post: #1
Wink Exception:com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for colu
When you get this error while running jsp program "Exception in Upload.jsp-->com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'columnname' at row 1"

The first thing to lookup is mysql database table columns datatype.

For uploading or inserting large images or texts you need to assign datatype as "blob or longblob" Then these errors are avoided. What we do mistake is we are uploading simple text or image for testing but at real time these are not enough carefull testing makes program error free,

Happy Coding
Find all posts by this user
Add Thank You Quote this message in a reply
Post Reply 


Possibly Related Threads...
Thread: Author Replies Views: Last Post
  Display data from database in php rajasri 0 826 12-14-2011 11:52 AM
Last Post: rajasri
Sad how to export a csv using INTO syntax of mysql rajasri 0 531 12-13-2011 12:12 AM
Last Post: rajasri
Tongue Retrieve values between two numbers in mysql rajasri 0 1,163 12-13-2011 12:09 AM
Last Post: rajasri
Smile How to backup database of mysql using bat rajasri 0 867 12-12-2011 10:11 PM
Last Post: rajasri

Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Like Our Facebook Page