TYPE
This is not a table description.
This is a matrix that shows what are the data types used to store data depending on the database server type.
As example, we store documents in binary mode in document domain (obj_x_documents)
and we use the
LONG RAW data type with Oracle Server.
int10 | int6 | int1 | char(n) | blob | |
Oracle | NUMBER(10) | NUMBER(6) | NUMBER(1) | VARCHAR2(n) | LONG RAW |
Sybase | NUMERIC(10) | NUMERIC(6) | NUMERIC(1) | VARCHAR(n) | IMAGE |
DB2 UDB | INTEGER | DECIMAL(6) | DECIMAL(1) | VARCHAR(n) | LONG VARCHAR FOR BIT DATA |
ODBC/MS ACCESS | LONG | DOUBLE | DOUBLE | TEXT(n) | LONGBINARY |
ODBC/TERADATA | INTEGER | DECIMAL(6) | DECIMAL(1) | VARCHAR(n) | VARBYTE(20480) |
ODBC/IBM DB2 | INTEGER | DECIMAL(6) | DECIMAL(1) | VARCHAR(n) | VARCHAR(255) |
ODBC/RDB | INTEGER | DECIMAL(6) | DECIMAL(1) | VARCHAR(n) | LONG VARCHAR |
ODBC/INFORMIX | INTEGER | DECIMAL(6) | DECIMAL(1) | VARCHAR(n) | BYTE |
ODBC/SYBASE | NUMERIC(10) | NUMERIC(6) | NUMERIC(1) | VARCHAR(n) | IMAGE |
ODBC/MS SQL Server | NUMERIC(10) | NUMERIC(6) | NUMERIC(1) | VARCHAR(n) | IMAGE |
RedBrick | integer | int | int | char(n) | char(1024) |
ODBC/INGRES | INTEGER | INTEGER | INTEGER | VARCHAR(n) | VARCHAR(1500) |