SQL Data Types

Depending on their histories, different SQL implementations support a variety of data types. The SQL specification recognizes nine predefined general types, shown in the lists below.

Exact Numerics:

• INTEGER

• SMALLINT

• BIGINT

• NUMERIC

• DECIMAL

• DECFLOAT

Approximate Numerics:

• REAL

• DOUBLE PRECISION

• FLOAT

Boolean:

• BOOLEAN

Character Strings:

• CHARACTER (CHAR)

• CHARACTER VARYING (VARCHAR)

• NATIONAL CHARACTER (NCHAR)

• NATIONAL CHARACTER VARYING (NVARCHAR)

Datetimes:

• DATE

• TIME

• TIMESTAMP

• TIME WITH TIMEZONE

• TIMESTAMP WITH TIMEZONE

Intervals:

• INTERVAL DAY

• INTERVAL YEAR

Large Objects:

• BLOB

• CLOB

Collection Types:

• ARRAY

• MULTISET

Other Types:

• ROW

• XML