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