Integer Data Types

Here is some examples of the integer data types. When deciding on a integer for a column, variable, parameter or expression it is a wise choice to choose the most efficient data type based off of size and usage.

TINY INTEGER – The tiny integer data type allows for whole numbers between 0 and 255 and only uses 1 byte of data.

SMALL INTEGER – The small integer data type allows for a whole number between -32678 to a positive value of 32767 and will consume 2 bytes of data.

REGULAR INTEGER –The regular integer data type allows for a whole number between -2147483648 to a positive value 2147483647 and will consume 4 bytes of data.

BIG INTEGER- The big integer data type allows for a whole number between -9 quintillion to a value of positive 9 quintillion and will consume 8 bytes of data.

2 Comments on "Integer Data Types"

  1. Thank you, I’ve recently been looking for info approximately this subject for
    a while and yours is the greatest I’ve found out till now.

    But, what in regards to the conclusion? Are you positive in regards to the source?

    • John Deardurff | January 4, 2018 at 4:40 pm | Reply

      I am unsure what you mean in regards to the conclusion. Then I would be happy to answer your question in more detail.

Leave a comment

Your email address will not be published.


*