Figure 5 2   DB2 UDB data types
MySQL data types are grouped into three categories, and can be converted to 
DB2 UDB data types following the rules suggested below:
Numeric type
  TINYINT
This is a single byte integer, DB2 UDB does not have built in single byte 
integer but SMALLINT is used for all the similar functionality.
  SMALLINT
A small integer is a two byte integer with a precision of five digits. This can 
be replaced by DB2 UDB SMALLINT.
  BIT/BOOL/BOOLEAN
These are synonyms for TINYINT(1), In DB2 UDB we use SMALLINT with 
check constraint instead of BIT/BOOL/BOOLEAN.
 Chapter 5. Database porting 
91






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