MySQL Forums
Forum List  »  MySQL Workbench

After upgrade to MySQL Workbench 6: error1406. Data too long for column
Posted by: Andre Müller
Date: March 31, 2014 03:46AM

Hi

I have the following situation: In my DB I have a stored procedure which copies data from one table/view to another table. Source and Target fields are identical with identical length. I executed this SP thousands of times with workbench 5.2.
Now I upgraded to workbench 6.0 and when executing the stored procedure I get at one point of time this error:
Error Code: 1406. Data too long for column 'tablename' at row 1

The target table should contain 10'000 records, the error occurs once after 8'000.

I searched for this error code but it does not make sense, because source and target fields are the same plus it worked with workbench 5.2

Any idea?

thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
After upgrade to MySQL Workbench 6: error1406. Data too long for column
2750
March 31, 2014 03:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.