MySQL 数据类型如何映射到 DB2 数据类型
数据类型映射
MySQL 数据类型 | DB2 数据类型 |
TINYINT | SMALLINT |
SMALLINT | SMALLINT |
MEDIUMINT | INTEGER |
INT | INTEGER |
INTEGER | INTEGER |
BIGINT | BIGINT |
REAL | DOUBLE |
DOUBLE | DOUBLE |
FLOAT | DOUBLE |
DECIMAL(p,s)
其中: s > 0 && p >= s s > 0 && p < s s < 0 |
DECIMAL(min(p,31), min(s,31)) DECIMAL(min(p,31), min(s,31)) DECIMAL(min(p,31),0) |
NUMERIC(p,s)
其中: s > 0 && p >= s s > 0 && p < s s < 0 |
DECIMAL(min(p,31), min(s,31)) DECIMAL(min(p,31), min(s,31)) DECIMAL(min(p,31),0) |
TINYINT UNSIGNED | SMALLINT |
SMALLINT UNSIGNED | INTEGER
可选: SMALLINT |
MEDIUMINT UNSIGNED | INTEGER |
INT UNSIGNED | BIGINT
可选: INTEGER |
BIGINT UNSIGNED | DECIMAL(20,0)
可选: BIGINT |
REAL UNSIGNED | DOUBLE
可选: DOUBLE |
DOUBLE UNSIGNED | DECIMAL(p,s) |
FLOAT UNSIGNED | DOUBLE |
DECIMAL UNSIGNED | DECIMAL(p,s) |
NUMERIC UNSIGNED | DECIMAL(p,s) |
DATE | DATE |
TIME | TIME |
TIMESTAMP | TIMESTAMP |
DATETIME | TIMESTAMP
可选: TIME |
YEAR | CHAR(4) |
CHAR(l) | CHAR(l)
可选: VARCHAR |
VARCHAR(l) | VARCHAR(l)
可选: CLOB |
TINYBLOB | BLOB(255) |
BLOB | BLOB(65535) |
MEDIUMBLOB | BLOB(16777215) |
LONGBLOB | BLOB(2000000000) |
TINYTEXT | CLOB(255) |
TEXT | CLOB(65535) |
MEDIUMTEXT | CLOB(16777215) |
LONGTEXT | CLOB(2000000000) |