Share ThisSQL Data Types
Part of the SQL All-in-One Cheat Sheet
Depending on their histories, different SQL implementations support a variety of data types. The SQL specification recognizes six predefined general types, shown in this table.
| Exact Numerics | Datetimes |
|---|---|
| INTEGER | DATE |
| SMALLINT | TIME |
| BIGINT | TIMESTAMP |
| NUMERIC | TIME WITH TIMEZONE |
| DECIMAL | TIMESTAMP WITH TIMEZONE |
| Approximate Numerics | Intervals |
| REAL | INTERVAL DAY |
| DOUBLE PRECISION | INTERVAL YEAR |
| FLOAT | Large Objects |
| Boolean | BLOB |
| BOOLEAN | CLOB |
| Character Strings | Collection Types |
| CHARACTER | ARRAY |
| CHARACTER VARYING (VARCHAR) | MULTISET |
| NATIONAL CHARACTER | Other Types |
| NATIONAL CHARACTER VARYING | ROW |
| XML |
Comments (0)
Leave a Reply