In the last episode (Dec 14), A Pasetti said: > When attempting to insert an integer into an integer column, a > different value is being inserted for the given row. Check out the > sql below to see what I mean. The integer 7819359281 is somehow > changed to 2147483647 when it's inserted. > > Perhaps someone has experienced this problem and could suggest a fix. > I'm using MySQL 4.0.
Use a larger numeric type. http://www.mysql.com/doc/en/Numeric_types.html Type Bytes From To TINYINT 1 -128 127 SMALLINT 2 -32768 32767 MEDIUMINT 3 -8388608 8388607 INT 4 -2147483648 2147483647 BIGINT 8 -9223372036854775808 9223372036854775807 -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
