Data Types: Binary Integer

Except for Oracle, the platforms support the following binary integer types:

SMALLINT
INTEGER
BIGINT

These types correspond to 2-byte, 4-byte, and 8-byte integers, respectively. Ranges are −32,768 to 32,767; −2,147,483,648 to 2,147,483,647; and −9,223,372,036,854,775,808 to 9,223,372,036,854,775,807, respectively.

Get SQL Pocket Guide, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.