2. SQL Data Types : Data Types : Integer Data Types
 
Share this page                  
Integer Data Types
Exact numeric data types include the following integer data types:
• INTEGER1 or TINYINT (one-byte)
• INTEGER 2 or SMALLINT (two-byte)
• INTEGER4 or INTEGER (four-byte)
• INTEGER8 or BIGINT (eight-byte)
The following table lists the ranges of values for each integer data type:
Integer Data Type
Lowest Possible Value
Highest Possible Value
INTEGER1
-128
+127
INTEGER2
-32,768
+32,767
INTEGER4
-2,147,483,648
+2,147,483,647
INTEGER8
-9,223,372,036,854,775,808
+9,223,372,036,854,775,807