| CHAR(n) |
CHAR(n) (limit = page size, ex:16384
bytes) |
| VARCHAR(n[,m]) |
VARCHAR(n) (limit = page size,
ex:16384 bytes) |
| LVARCHAR(n) |
VARCHAR(n) (limit = page size,
ex:16384 bytes) |
| NCHAR(n) |
NCHAR(n) (length in characters) |
| NVARCHAR(n[,m]) |
NVARCHAR(n) (length in characters) |
| BOOLEAN |
BIT (must be NOT NULL!) |
| SMALLINT |
SMALLINT |
| INT / INTEGER |
INTEGER |
| BIGINT |
BIGINT |
| INT8 |
BIGINT |
| SERIAL without start value! |
INTEGER (see note 1) |
| BIGSERIAL without start value! |
BIGINT (see note 1) |
| SERIAL8 without start value! |
BIGINT (see note 1) |
| DOUBLE PRECISION / FLOAT[(n)] |
DOUBLE PRECISION |
| REAL / SMALLFLOAT |
REAL |
| NUMERIC / DEC / DECIMAL(p,s) |
DECIMAL(p,s) |
| NUMERIC / DEC / DECIMAL(p) with
p<=19 |
DECIMAL(2*p,p) |
| NUMERIC / DEC / DECIMAL(p) with
p>19 |
N/A |
| NUMERIC / DEC / DECIMAL |
DECIMAL(32,16) |
| MONEY(p,s) |
DECIMAL(p,s) |
| MONEY(p) |
DECIMAL(p,2) |
| MONEY |
DECIMAL(16,2) |
| DATE |
DATE(yyyy-mm-dd) |
| DATETIME HOUR TO FRACTION(n) |
BIGTIME(hh:mm:ss.ffffff) |
| DATETIME HOUR TO SECOND |
BIGTIME(hh:mm:ss.ffffff) |
| Other sort of DATETIME type |
BIGDATETIME(yyyy-mm-dd hh:mm:ss.ffffff) |
| INTERVAL q1 TO q2 |
CHAR(50) |
| TEXT |
TEXT |
| BYTE |
IMAGE |