If an INT has a fixed range, then what is the point of giving it scale? As in, "int(12)".
In Oracle, a NUMBER(12) indicates how many digits you could have (in this case, 99999999999 would be the max value). Would an int(2) allow -99 to 99, or -2147483648 to 2147483647? Maybe MySQL should throw an error if someone tries to create an int(xyz) column that exceeds the size of an int? David. ----- Original Message ----- From: "Dan Nelson" <[EMAIL PROTECTED]> To: "A Pasetti" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December 14, 2003 6:48 PM Subject: Re: integer not being inserted correctly > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]