| CHAR(n) |
CHAR(n) COLLATE RTRIM |
| VARCHAR(n[,m]) |
VARCHAR(n) COLLATE RTRIM |
| LVARCHAR(n) |
VARCHAR(n) COLLATE RTRIM |
| NCHAR(n) |
NCHAR(n) |
| NVARCHAR(n) |
NVARCHAR(n) |
| BOOLEAN |
BOOLEAN |
| SMALLINT |
SMALLINT |
| INT / INTEGER |
INTEGER |
| BIGINT |
BIGINT |
| INT8 |
BIGINT |
| SERIAL[(start)] |
INTEGER (see note 1) |
| BIGSERIAL[(start)] |
N/A (see note 1) |
| INT8[(start)] |
N/A (see note 1) |
| DOUBLE PRECISION / FLOAT[(n)] |
FLOAT |
| REAL / SMALLFLOAT |
SMALLFLOAT |
| NUMERIC / DEC / DECIMAL(p,s) |
DECIMAL(p,s) |
| NUMERIC / DEC / DECIMAL(p) |
DECIMAL(p,s) |
| NUMERIC / DEC / DECIMAL |
DECIMAL |
| MONEY(p,s) |
DECIMAL(p,s) |
| MONEY(p) |
DECIMAL(p,2) |
| MONEY |
DECIMAL(16,2) |
| TEXT |
TEXT |
| BYTE |
BLOB |
| DATE |
DATE |
| DATETIME HOUR TO MINUTE |
SMALLTIME |
| DATETIME HOUR TO SECOND |
TIME |
| DATETIME HOUR TO FRACTION(n) |
TIME(n) |
| DATETIME YEAR TO DAY |
TINYDATETIME |
| DATETIME YEAR TO MINUTE |
SMALLDATETIME |
| DATETIME YEAR TO SECOND |
DATETIME |
| DATETIME YEAR TO FRACTION(n) |
DATETIME(n) |
| DATETIME q1 TO q2 (different from
above) |
TIMESTAMP |
| INTERVAL q1 TO q2 |
CHAR(50) |