SingleStore Managed Service

Integer Numbers

Data Type

Size

Size (Not Null)

Synonyms

Min Value

Max Value

BOOL* (see note below)

2 bytes

1 byte

BOOLEAN

-128

127

BIT

9 bytes

8 bytes

TINYINT

2 bytes

1 byte

-128

127

SMALLINT

4 bytes

2 bytes

-32768

32767

MEDIUMINT

4 bytes

3 bytes

-8388608

8388607

INT

8 bytes

4 bytes

INTEGER

-2147483648

2147483647

BIGINT

12 bytes

8 bytes

-2 ** 63

(2 ** 63) - 1

Remarks

BOOL and BOOLEAN are synonymous with TINYINT. A value of 0 is considered FALSE, non-zero values are considered TRUE.

The format: INT(x) (for example, INT(5)) is used to specify display width and not the size of the integer. Display width is not directly used within SingleStore DB but may be used by some clients.