This is an old revision of the document!
Ispirer Home Page
Ispirer SQLWays Product Page - Migration to IBM DB2
Request SQLWays
IBM DB2 Data Types
Versions: IBM DB2 9.x, 8.x, 7.x, 6.1 and 5.2
Data Type | Parameters and Range |
---|---|
Character Data Types | |
CHAR(n) - Fixed-length character data | 1 ⇐ n ⇐ 254, default is 1 |
GRAPHIC(n) - Fixed-length double-byte character data | 1 ⇐ n ⇐ 127, default is 1 |
VARCHAR(n) - Variable-length character data | 1 ⇐ n ⇐ 32672, n is mandatory |
Data Types in Other Databases
Oracle | SQL Server | MySQL | PostgreSQL | Sybase ASE | Sybase ASA | Informix DS | Teradata | HP Neoview | Interbase/Firebird | Ingres |
Ispirer Home Page
Ispirer SQLWays Product Page - Migration to IBM DB2
Request SQLWays