SQL data types

File Format
Name	SQL data types
Ontology	Electronic File Formats Data types SQL data types

ANSI SQL

Character strings

• CHARACTER
• VARCHAR
• NCHAR
• NVARCHAR

Sequences of bits

• BIT
• BIT VARYING

Numeric

• INTEGER
• SMALLINT
• BIGINT
• FLOAT
• REAL
• DOUBLE PRECISION
• NUMERIC

Time

• DATE
• TIME
• TIMESTAMP
• TIMETZ
• TIMESTAMPTZ

Null

There is a special value NULL, which means the lack of any value in the column.