Set the fieldtype to 'bigint'
It's the limit on int
"Jeff McKeon" <[EMAIL PROTECTED]>
05/25/2004 02:29 PM
To: <[EMAIL PROTECTED]>
cc:
Subject: Very Strange data corruption
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]
