Integer Data Types

SQL Language StructureCommon Language Elements

Integer Data Types

The SMALLINT, INTEGER, BIGINT and INT128 data types are used for integers of various precision in Dialect 3.Firebird does not support an unsigned integer data type.

`SMALLINT`

The 16-bit SMALLINT data type is for compact data storage of integer data for which only a narrow range of possible values is required.Numbers of the SMALLINT type are within the range from -2¹⁶ to 2¹⁶ - 1, that is, from -32,768 to 32,767.

SMALLINT Examples

CREATE DOMAIN DFLAG AS SMALLINT DEFAULT 0 NOT NULL
  CHECK (VALUE=-1 OR VALUE=0 OR VALUE=1);

CREATE DOMAIN RGB_VALUE AS SMALLINT;