Re: .MysqlDataTruncation: Data truncation: Out of range value for column 'mobile'
Posted by: Todd Farmer
Date: October 30, 2012 10:36AM

Hi Rekha,

The error message pretty much spells it out - you attempted to insert a value into a column whose definition means it cannot store the data with full precision. Examples of this include:

* a negative number in an UNSIGNED INTEGER column
* a string ("TEST") that is longer than the column definition (VARCHAR(2))
* a string using a character set which cannot be represented by the character set defined for the column
* a number out of bounds (e.g., 128 in a TINYINT column)
* an invalid or out-of-range date

You would have to log the actual query attempted to know exactly what's being attempted.

Hope that helps!

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/

Options: ReplyQuote


Subject
Written By
Posted
Re: .MysqlDataTruncation: Data truncation: Out of range value for column 'mobile'
October 30, 2012 10:36AM


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.