Glitch Posted December 10, 2018 Report Share Posted December 10, 2018 What is the difference when using Number DataType from Integer DataType? When should I use them? Quote Link to comment Share on other sites More sharing options...
0 ManokNaPula Posted December 10, 2018 Report Share Posted December 10, 2018 You should use a Number DataType when you are trying to store Numbers with decimals. Use integer when you want to use whole numbers. A Number DataType accepts -9999.99 to +9999.99 An Integer DataType accepts -9999 to +9999. Hope this helps! Quote Link to comment Share on other sites More sharing options...
0 Kurumi Posted December 11, 2018 Report Share Posted December 11, 2018 Hi @Sammeeh You can check the howto article for more information about Data types: https://howto.caspio.com/tables-and-views/data-types/ Ciao! Quote Link to comment Share on other sites More sharing options...
0 vanderLeest Posted May 20, 2020 Report Share Posted May 20, 2020 The limit for Number fields is 15 digits (including a floating decimal), and 10 digits for an Integer field. A minus sign counts as a digit in the case. Quote Link to comment Share on other sites More sharing options...
0 nisargshah Posted May 21, 2020 Report Share Posted May 21, 2020 Thanks to them who have provided answers. Quote Link to comment Share on other sites More sharing options...
0 sandy159 Posted April 21, 2022 Report Share Posted April 21, 2022 Just to add to this topic. The range for an integer data type is -2,147,483,648 to 2,147,483,647. More can be checked here: Data Type Ranges If a bigger number needs to be used, please use the Number data type which allows 15 digits (including a floating decimal) as mentioned above. Quote Link to comment Share on other sites More sharing options...
0 Queso Posted May 1, 2022 Report Share Posted May 1, 2022 Hello, On my table level, I found out that the Number data type is limited to 15 character (excluding the decimal) while the Integer is limited to 10 characters. I can't also type a dot/point on the integer field. Well... that is expected because integers don't have decimals. Quote Link to comment Share on other sites More sharing options...
Question
Glitch
What is the difference when using Number DataType from Integer DataType? When should I use them?
Link to comment
Share on other sites
6 answers to this question
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.
Note: Your post will require moderator approval before it will be visible.