| BIGINT |
BIGINT |
BIGINT |
| BIGSERIAL[(start)] |
BIGSERIAL[(start)] |
BIGSERIAL[(start)] |
| BOOLEAN |
BOOLEAN |
BOOLEAN |
| BYTE |
BYTE (= BLOB) (using <=
2Gb!) |
BYTE (= BLOB) (using <=
2Gb!) |
| CHAR(n) |
CHAR(n) |
CHAR(n) |
| CHARACTER VARYING(n,m) |
VARCHAR(n,m) (= VARCHAR
(n)) |
VARCHAR(n,m) (= VARCHAR
(n)) |
| CHARACTER(n) |
CHARACTER(n) (= CHAR (n)) |
CHARACTER(n) (= CHAR (n)) |
| DATE |
DATE |
DATE |
| DATETIME HOUR TO SECOND |
TIME |
DATETIME HOUR TO SECOND |
| DATETIME q1 TO q2 (different
from above) |
TIMESTAMP |
DATETIME q1 TO q2 |
| DECIMAL(p,s) |
DECIMAL(p,s)! p<=15 |
DECIMAL(p,s) (p<=32,
FGL/IFX limit) |
| DECIMAL(p) |
N/A until Genero db 3.90 |
N/A until Genero db 3.90 |
| DECIMAL |
DECIMAL |
DECIMAL |
| DOUBLE PRECISION |
DOUBLE PRECISION (= DOUBLE) |
DOUBLE PRECISION (= DOUBLE) |
| FLOAT(n) |
FLOAT(n) (= DOUBLE) |
FLOAT(n) (= DOUBLE) |
| INT |
INT |
INT |
| INT8 |
INT8 (= BIGINT) |
INT8 (= BIGINT) |
| INTEGER |
INTEGER |
INTEGER |
| INTERVAL q1 TO q2 |
CHAR(50) |
INTERVAL q1 TO q2 |
| MONEY(p,s) |
DECIMAL(p,s)! p<=15 |
DECIMAL(p,s) (p<=32,
FGL/IFX limit) |
| MONEY(p) |
DECIMAL(p,2)! p<=15 |
DECIMAL(p,2) (p<=32,
FGL/IFX limit) |
| MONEY |
DECIMAL(16,2)! not supported,
since precision is greater than 15 |
DECIMAL(16,2) |
| NCHAR(n) |
NCHAR(n) |
NCHAR(n) |
| NUMERIC(p,s) |
DECIMAL(p,s) |
DECIMAL(p,s) |
| NUMERIC(p) |
N/A until Genero db 3.90 |
N/A until Genero db 3.90 |
| NUMERIC |
DECIMAL |
DECIMAL |
| NVARCHAR(n) |
NVARCHAR(n) |
NVARCHAR(n) |
| REAL |
REAL (64-bit in Genero
db!) |
REAL (64-bit in Genero
db!) |
| SERIAL[(start)] |
SERIAL[(start)] |
SERIAL[(start)] |
| SERIAL8[(start)] |
SERIAL8[(start)] |
SERIAL8[(start)] |
| SMALLFLOAT |
SMALLFLOAT (64b in Genero
db!) |
SMALLFLOAT (64b in Genero
db!) |
| SMALLINT |
SMALLINT |
SMALLINT |
| TEXT |
TEXT (= CLOB) (using <=
2Gb!) |
TEXT (= CLOB) (using <=
2Gb!) |
| VARCHAR(n,m) |
VARCHAR(n,m) (= VARCHAR(n)) |
VARCHAR(n,m) (= VARCHAR(n)) |
| VARCHAR(n) |
VARCHAR(n) |
VARCHAR(n) |
| LVARCHAR(n) |
VARCHAR(n) |
VARCHAR(n) |