MySQL 4.1

DB2 UDB 8.1

TIMESTAMP

TIMESTAMP

TIME

TIME

YEAR

SMALLINT with check constraint

CHAR

CHAR

VARCHAR

VARCHAR

TINYBLOB

BLOB(255)

TINYTEXT

CLOB(255)

BLOB BLOB(65K)

TEXT VARCHAR2,

CLOB(65K)

MEDIUMBLOB BLOB(16M)

MEDIUMTEXT CLOB(16M)

LONGBLOB

BLOB(2G) NOT LOGGED

LONGTEXT RAW,

CLOB(2G) NOT LOGGED

ENUM VARCHAR2,

VARCHAR() with check constraints

SET VARCHAR2,

VARCHAR() with check constraints

5.2  Data Definition Language differences

In this section we address the Data Definition Language (DDL) syntax difference 

between MySQL and DB2 DDL statements, and provide the DB2 UDB 

conversion. These differences can be syntactical, semantic, or functional.

Both MySQL and DB2 UDB follows structured query language (SQL), 

standardized language used to access databases, and is defined by the 

ANSI/ISO. 

The data definition language is a subset of SQL, which serves to create or delete 

a database and its structure (tables, views, and indexes); to grant or revoke user 

privileges; and to define referential integrity rules.

 Chapter 5. Database porting 

95