Actually the Field type is fine. It was user input error. The person who created the ship ID added an extra digit, normally they are only 9 digits long. I didn't catch it until I looked at a list of all the ShipID's together and then it stuck out like a sore thumb.
Thanks for all the explanations.. Jeff > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 25, 2004 2:41 PM > To: Jeff McKeon > Cc: [EMAIL PROTECTED] > Subject: Re: Very Strange data corruption > > > > 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,puk > 2,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/mysql?> [EMAIL PROTECTED] > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
