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)