A timestamp in MySQL is date time combination with range of 1970 01 01 
00:00:00 to the year 2037. It automatically set to the date and time of the 
most recent operation if you do not give it a valid value. This is same as 
timestamp in DB2 UDB except for its range.
  TIME
MySQL time represents a clock ranging from  838:59:59 to 838:59:59. It is 
mapped to DB2 UDB time, which is a 24 hour clock.
  YEAR
A year in two or four digit format representing the year from 1901 to 2155. 
It is mapped to SMALLINT in DB2.
String/character types
  CHAR
A fixed length string in MySQL is represented with the same name in DB2 
UDB, It can be mapped to CHAR in DB2.
  VARCHAR
A variable length string is also same as DB2 UDB VARCHAR for its range, 
which is 0 255 characters in MySQL and 0 32672 bytes in DB2.
  TINYBLOB
MySQL tinyblob is a binary large object column with a maximum length of 
255. This is mapped to DB2 BLOB(255).
  TINYTEXT
MySQL tinytext is a character stream of maximum length 255. It is mapped 
to DB2 CLOB(255).
  BLOB
MySQL blob is a binary data column with a maximum length of 65535. 
This is mapped to DB2 BLOB(65K).
  TEXT
This is a text column with a maximum length of 65535 and is mapped to 
DB2 CLOB(65K).
  MEDIUMBLOB
MySQL mediumblob is a blob column with a maximum length of 
16777215. This can be mapped to DB2 BLOB(16M).
  MEDIUMTEXT
MySQL mediumtext is a text column with a maximum length of 16777215. 
This can be mapped to DB2 CLOB(16M).
  LONGBLOB
 Chapter 5. Database porting 
93






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