DB2 UDB data type

Java type

 Data type description

DOUBLE

double

Double precision floating 

point

DECIMAL

java.math.BigDecimal

Packed decimal

CHAR

java.lang.String

Fixed length character 

string of length n where n is 

from 1 to 254

CHAR FOR BIT DATA

byte[]

Fixed length character 

string of length n where n is 

from 1 to 254

VARCHAR

java.lang.String

Variable length character 

string

VARCHAR FOR BIT DATA

byte[]

Variable length character 

string

LONG VARCHAR

java.lang.String

Long variable length 

character string

LONG VARCHAR FOR 

byte[]

Long variable length 

BIT DATA

character string

BLOB

java.sql.Blob

Large object 

variable length binary 

string

CLOB

java.sql.Clob

Large object 

variable length character 

string

DBCLOB(n)

java.sql.Clob

Large object 

variable length 

double byte character 

string

GRAPHIC

java.lang.String

Fixed length double byte 

character string

VARGRAPHIC

 java.lang.String

Non null terminating 

varying double byte 

character string with 2 byte 

string length indicator

LONG VARGRAPHIC

 java.lang.String

Non null terminating 

varying double byte 

character string with 2 byte 

string length indicator

198 

MySQL to DB2 UDB Conversion Guide