MySQL longblob is very large blob column with a maximum length of 

4294967295. It is generally mapped to DB2 BLOB(4G) not logged.

  LONGTEXT RAW

MySQL longtext is text column with a maximum length of 4294967295 is 

generally mapped to DB2 CLOB(4G) not logged.

  ENUM VARCHAR2

MySQL has a special type enumeration, which is a string object that can 

have only one value chosen from the list of values `value1',  value2 ,..., 

NULL. This is implemented in DB2 UDB using VARCHAR() with check 

constraints.

  SET VARCHAR2

Another MySQL special type set. It is a string object that can have zero or 

more values, which must be chosen from the list of values  value1 , 

 value2 ,... This is implemented in DB2 UDB using VARCHAR() with check 

constraints.

Table 5 1 shows the default data type mappings between two databases used by 

MTK and the sample application.

Table 5 1   Default data type mapping

MySQL 4.1

DB2 UDB 8.1

TINYINT

SMALLINT

SMALLINT

SMALLINT

MEDIUMINT

INTEGER

INT

INTEGER

INTEGER

INTEGER

BIGINT

BIGINT

FLOAT

FLOAT

DOUBLE

DOUBLE

REAL

REAL

DECIMAL

DECIMAL

NUMERIC

NUMERIC

DATE

DATE

DATETIME

TIMESTAMP

94 

MySQL to DB2 UDB Conversion Guide