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? Quote 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. Quote 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!!! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.