» Documentation » SQL Reference

SQL Data Types

Internal Id

Type Names

Storage Requirement

Limits

Type description

2

TINYINT, SMALLINT

2 bytes

-32,768 to 32,767

Signed integer

3

INT, INTEGER

4 bytes

-2,147,483,648 to 2,147,483,647

Signed integer

32769

BIGINT

8 bytes

2^63 to 2^63-1

Signed long integer

4

FLOAT

4 bytes

+/- 3.4E +/- 38 (7 digits)

Floating point value

5

DOUBLE

8 bytes

+/- 1.7E +/- 308 (15 digits)

Double float value

6

DATETIME

8 bytes

0100-01-01 00:00:00 to 9999-31-12 23:59:59

Date-Time value. Format: Year/Month/Day Hour:Min:Sec. Example: 19/01/1972 12:20:00

8

CHAR, VARCHAR

Length of string + 1 byte for zero terminator

size up to 8 KB

String of text characters. Cannot contain a null characters.

72

GUID

16 bytes

0 to 2^128 -1

Globally unique identifier

32768

UNIQUEIDENTIFIER / AUTOBIGINT

8 bytes

0 to 2^64 -1

Automatically incrementing column value by 1024. Cannot be set by the user.

32771

BLOB

size of data

32 TB

Any binary character data

32770

TEXT

size of text

32 TB

Any text character data

25

NCHAR, NVARCHAR

2 * Length of string + 1 byte for zero terminator

4kb

Unicode text

32772

NTEXT

Size of unicode text

32 TB

Unicode text

102

BIT

1 byte

0/1

Used as boolean type