5.1  Data type mapping

This section compares MySQL and DB2 UDB data types. In general, DB2 UDB 

has data types equivalent to all the existing data types in MySQL.

Every column in database tables has a data type and this data type determines 

the value that column can contain in it. DB2 UDB has built in data types and 

supports user defined data type (UDT) whereas MySQL has only built in data 

types support. 

Figure 5 1 shows built in data type of MySQL.

MySQL

data

types

Numeric

Date and

String

Types

Time

Type

Exact

Approximate

CHAR

VARCHAR

BLOB

TEXT

ENUM

SET

Float

Real

Double

TinyBLOB

MediumBLOB

TinyTEXT

MediumTEXT

Small

Numeric

Decimal

Integer

INT

TinyInt

MediumInt

BigInt

DateTime

Date

TimeStamp

Time

Year

Figure 5 1   MySQL data types

Figure 5 2 shows built in data types supported by DB2 UDB.

90 

MySQL to DB2 UDB Conversion Guide