MySQL Forums
Forum List  »  MySQL for Excel

Advanced Search
New Topic

Re: Value was either too large or too small for an unsigned byte
Posted by: Javier Treviño
Date: September 25, 2013 12:07PM

Hi William,
Thanks for writing in our forums!

Based on what you wrote it seems to me that you are trying to assign a negative number to an unsigned byte so the error message you get is a validation error. Can you confirm that the data type of that column is an unsigned byte?

If that is the case the MySQL Server will not let any negative values set to the column. If you need that changed you will need to have the column data type changed to one that allows for negative values as well.

Regards.

====================================
Javier Treviño
MySQL on Windows Team

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Value was either too large or too small for an unsigned byte
5053
William Marriott
September 19, 2013 02:30PM
Re: Value was either too large or too small for an unsigned byte
2202
Javier Treviño
September 25, 2013 12:07PM
Re: Value was either too large or too small for an unsigned byte
1722
William Marriott
September 26, 2013 03:12PM
Re: Value was either too large or too small for an unsigned byte
1589
Javier Treviño
November 07, 2013 12:55PM


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.