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.