Column type differences between databases

The column types presented in the online version of the WebSphere Commerce database schema are based on DB2 running on AIX.

The following table provides equivalent column types for operating systems and databases supported by WebSphere Commerce.

BIGINT NUMBER BIGINT
BLOB() BLOB BLOB()
CHAR() VARCHAR2() GRAPHIC()
CCSID 13488
CHAR() FOR BIT DATA RAW() CHAR() FOR BIT DATA
CLOB() CLOB() DBCLOB() CCSID 13488
DECIMAL(,) NUMBER(,) DECIMAL(,)
FLOAT NUMBER FLOAT
INTEGER INTEGER INTEGER
TIMESTAMP DATE TIMESTAMP
VARCHAR() VARCHAR2() VARGRAPHIC()
CCSID 13488
LONG VARCHAR LONG() VARGRAPHIC(4000)
ALLOCATE(1000)
CCSID 13488 (see Note below)
LONG VARCHAR FOR BIT DATA LONG RAW VARCHAR(8000)
ALLOCATE(1000) FOR BIT DATA

Note: In the CATENTDESC table, the AUXDESCRIPTION2 field is VARGRAPHIC(3000) ALLOCATE() CCSID 13488.