• 0

# Difference of Number and Integer

## Question

What is the difference when using Number DataType from Integer DataType? When should I use them?

## Recommended Posts

• 0

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!

##### Share on other sites

• 0

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.

##### Share on other sites

• 0

Thanks to them who have provided answers.

##### Share on other sites

• 0

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.

##### Share on other sites

• 0

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.

## 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.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.