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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved