Re: .MysqlDataTruncation: Data truncation: Out of range value for column 'mobile'
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/
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.