List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:December 15 2003 2:48am
Subject:Re: integer not being inserted correctly
View as plain text  
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
	dnelson@stripped
Thread
integer not being inserted correctlyA Pasetti15 Dec
  • Re: integer not being inserted correctlyDan Nelson15 Dec
  • Re: integer not being inserted correctlyPaul DuBois15 Dec
  • Re: integer not being inserted correctlyDavid Griffiths15 Dec
    • Re: integer not being inserted correctlyDaniel Kasak15 Dec
    • Re: integer not being inserted correctlyPaul DuBois15 Dec
    • RE: integer not being inserted correctlyMike Brando15 Dec
RE: integer not being inserted correctlyCharles E Sweet15 Dec