2. Language Elements : Data Types : Numeric Data Types : Integer Data Types
 
Share this page                  
Integer Data Types
Note:  Exact numeric data types includes the following integer data types:
• tinyint (one-byte)
• smallint (two-byte)
• integer (four-byte)
• integer8 (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
smallint (integer2)
-32,768
+32,767
integer (integer4)
-2,147,483,648
+2,147,483,647
integer8*
-9,223,372,036,854,775,808
+9,223,372,036,854,775,807
Note:  *OpenROAD does not support the Ingres Database intrinsic data type bigint.