Firebird Documentation Index → Firebird 2.1 Language Ref. Update → Data types and subtypes → BIGINT data type
Firebird Home Firebird Home Prev: Data types and subtypesFirebird Documentation IndexUp: Data types and subtypesNext: BLOB data type

BIGINT data type

Tip

Find a more recent version at Firebird 5.0 Language Reference: BIGINT

Added in: 1.5

Description: BIGINT is the SQL99-compliant 64-bit signed integer type. It is available in Dialect 3 only.

BIGINT numbers range from -263 .. 263-1, or -9,223,372,036,854,775,808 .. 9,223,372,036,854,775,807.

Example: 

create table WholeLottaRecords (
  id bigint not null primary key,
  description varchar(32)
)
Prev: Data types and subtypesFirebird Documentation IndexUp: Data types and subtypesNext: BLOB data type
Firebird Documentation Index → Firebird 2.1 Language Ref. Update → Data types and subtypes → BIGINT data type