samona Posted May 30, 2008 Share Posted May 30, 2008 Good Morning all, What type would I use for a field if I want to store numbers that can go up to a number in the millions? Link to comment https://forums.phpfreaks.com/topic/107990-solved-what-data-type-for-field-contains-number-in-millions/ Share on other sites More sharing options...
obsidian Posted May 30, 2008 Share Posted May 30, 2008 Good Morning all, What type would I use for a field if I want to store numbers that can go up to a number in the millions? If it is just millions, you can still use the INTEGER data type. By default, it stores up to 2,147,483,647 or 4,294,967,295 if you declare it as unsigned. If, for some reason, you end up getting above the 4 billion mark and still need to do calculations on it, you can use the BIGINT type. Link to comment https://forums.phpfreaks.com/topic/107990-solved-what-data-type-for-field-contains-number-in-millions/#findComment-553472 Share on other sites More sharing options...
samona Posted May 30, 2008 Author Share Posted May 30, 2008 Thank you!!! Link to comment https://forums.phpfreaks.com/topic/107990-solved-what-data-type-for-field-contains-number-in-millions/#findComment-553473 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.