Extremely weird INT handling

[nysebamse]

When inserting this integer: 000050007000003 from a form in php this is how it looked after being inserted: 000004294967295.

 

This is the structure of the table:

 

CREATE TABLE `kundekort_prosjekt_relation_kundekort` (

`id` int(11) NOT NULL auto_increment,

`prid` int(11) NOT NULL default \'0\',

`kid` int(15) unsigned zerofill NOT NULL default \'000000000000000\',

PRIMARY KEY (`id`)

) TYPE=MyISAM AUTO_INCREMENT=10 ;

 

 

I\'ve even tried inserting 000050007000003 manually with phpMyAdmin with the same result as described above.

 

Anyone has any suggestions to why this is occuring? Im pretty close to start chewing on my fist.. :evil:

[shivabharat]

Use a Big INT

 

CREATE TABLE `kundekort_prosjekt_relation_kundekort` ( 

`id` int(11) NOT NULL auto_increment, 

`prid` int(11) NOT NULL default \'0\', 

`kid` bigint(15) unsigned zerofill NOT NULL, 

PRIMARY KEY (`id`) 

) TYPE=MyISAM AUTO_INCREMENT=10; 

 

Because INT range is

-2147483648 to 2147483647.

 

Hope this helps

[nysebamse]

Thanks for your help

 

It worked great