SQL Data Types

External

• https://www.digitalocean.com/community/tutorials/sql-data-types

Internal

• SQL
• PostgreSQL Data Types

TODO

• Database-specific data types
• Working with different data types
• Conversion functions

Numeric Data Types

BIT

0,1

TINYINT

0..255

SMALLINT

-32,768..32,767

INT

-2,147,483,648..2,147,483,647

BIGINT

-9,223,372,036,854,775,808..9,223,372,036,854,775,807

DECIMAL, NUMERIC

-10^38 + 1 .. 10^38 - 1

FLOAT

-1.79E+308 .. 1.79E+308

REAL

-3.40E+38 .. 3.40E+38