| CHAR(n) |
CHAR(n) ( limit = 254c!
) |
CHAR(n) ( limit = 254c!
) |
| VARCHAR(n[,m]) |
VARCHAR(n) ( limit =
32672c! ) |
VARCHAR(n) ( limit = 32672c!
) |
| LVARCHAR(n) |
VARCHAR(n) ( limit =
32672c! ) |
VARCHAR(n) ( limit = 32672c!
) |
| NCHAR(n) |
N/A |
N/A |
| NVARCHAR(n[,m]) |
N/A |
N/A |
| BOOLEAN |
CHAR(1) |
CHAR(1) |
| SMALLINT |
SMALLINT |
SMALLINT |
| INT / INTEGER |
INTEGER |
INTEGER |
| BIGINT |
BIGINT |
BIGINT |
| INT8 |
BIGINT |
BIGINT |
| SERIAL[(start)] |
INTEGER (see notes) |
INTEGER (see notes) |
| BIGSERIAL[(start)] |
BIGINT (see notes) |
BIGINT (see notes) |
| SERIAL8[(start)] |
BIGINT (see notes) |
BIGINT (see notes) |
| DOUBLE PRECISION / FLOAT[(n)] |
FLOAT[(n)] / DOUBLE |
FLOAT[(n)] / DOUBLE |
| REAL / SMALLFLOAT |
REAL |
REAL |
| NUMERIC / DEC / DECIMAL(p,s) |
DECIMAL(p,s) (limit =
31 digits) |
DECIMAL(p,s) (limit =
31 digits) |
| NUMERIC / DEC / DECIMAL(p)
with p<=15 |
DECIMAL(2*p,p) |
DECFLOAT(16) |
| NUMERIC / DEC / DECIMAL(p)
with p>15 |
N/A |
DECFLOAT(16) if p=16, DECFLOAT(34)
if p>16 |
| NUMERIC / DEC / DECIMAL |
N/A |
DECFLOAT(34) |
| MONEY(p,s) |
DECIMAL(p,s) (limit
= 31 digits) |
DECIMAL(p,s) ( limit =
31 digits) |
| MONEY(p) |
DECIMAL(p,2) (limit
= 31 digits) |
DECIMAL(p,2) (limit =
31 digits) |
| MONEY |
DECIMAL(16,2) |
DECIMAL(16,2) |
| DATE |
DATE |
DATE |
| DATETIME HOUR TO SECOND |
TIME |
TIME |
| DATETIME q1 TO q2 (different
from above) |
TIMESTAMP |
TIMESTAMP |
| INTERVAL q1 TO q2 |
CHAR(50) |
CHAR(50) |
| TEXT |
CLOB(500K) |
CLOB(500K) |
| BYTE |
BLOB(500K) |
BLOB(500K) |