Jeff,
You are trying to exceed the limits of the INTEGER column. INTEGERs top out
at 2GB-1 (or 2147483647). May I suggest you change your table to use a
larger integer type like BIGINT. With BIGINT fields you can go all the way
to 9223372036854775807.
MySQL will give you the nearest possible number in the event of an overflow
or an underflow. That's why you see the "wrong" value for your column after
the INSERT.
Respectfully,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Jeff McKeon"
<[EMAIL PROTECTED] To: <[EMAIL PROTECTED]>
.com> cc:
Fax to:
05/25/2004 02:29 Subject: Very Strange data corruption
PM
Query:
insert into
MIS.simcard(ID,ShipID,Service_Provider,SN,v1,v2,f1,d1,puk1,puk2,pin1,pin
2,TwoStage,Status,DateAssigned,DateDisabled,UserID)
VALUES('NULL', '6889927707', '1', '8988169214000421398', '881621456175',
'', '', '881693156175', '62982149', '', '1111', '', '1307', '1',
'1085508771', 'NULL', 'jsm');
Always results in a ShipID field value of "2147483647" instead of
"6889927707"
Even if I just do a simple:
insert into MIS.simcard (ShipID) values ('6889927707');
It does the same darn thing.
ShipID is an Int(11) field
Version 4.0.15
If I change the first digit of the input from a 6 to any other digit, it
gets entered correctly. Any idea what is going on here!?
Version 4.0.15
Jeff
--
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]
