Column type differences between databases

The column types listed in this information center show the WebSphere Commerce database schema for DB2 for workstations. The following table provides equivalent column types for the operating systems and databases supported by WebSphere Commerce.

JDBC Object

WebSphere Commerce size limitation in bytes

(AIX)(Linux)(Solaris)(Windows)

(i5/OS)

(AIX)(Solaris)(Windows)

Long BIGINT BIGINT DECIMAL BIGINT NUMBER

9,223,372 x 1012

Hashtable BLOB() BLOB() BLOB() LONG VARBINARY BLOB 4 GB
String CHAR() GRAPHIC() CCSID 13488 CHAR() CHAR() VARCHAR() 254
byte[] CHAR() FOR BIT DATA CHAR() FOR BIT DATA CHAR() FOR BIT DATA BIT() RAW() 32,673
String CLOB() DBCLOB() CCSID 13488 CLOB() LONG VARCHAR CLOB

1 GB 4 GB

BigDecimal DECIMAL(,) DECIMAL(,) DECIMAL(,) DECIMAL(,) DECIMAL(,) -
Double FLOAT FLOAT FLOAT FLOAT NUMBER -
Integer INTEGER INTEGER INTEGER INTEGER INTEGER 2,147,483,647
Timestamp TIMESTAMP TIMESTAMP TIMESTAMP TIMESTAMP TIMESTAMP (9i) -
String VARCHAR() VARGRAPHIC() CCSID 13488 VARCHAR() VARCHAR() VARCHAR() 32,672
Related reference