OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Data Types > Numeric Data Types > Integer Data Type
Was this helpful?
Integer Data Type
There are four integer data types:
• tinyint (one-byte)
• smallint (two‑byte)
• integer (four‑byte)
• 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
tinyint (integer1)
-128
+127
smallint (integer2)
‑32,768
+32,767
integer (integer4)
‑2,147,483,648
+2,147,483,647
bigint (integer8)
-9,223,372,036,854,775,808
+9,223,372,036,854,775,807
Last modified date: 08/14/2024