MySQL源端映射到神通目的端

源数据类型 精度 小数位 长度 目的数据类型(默认) 精度 小数位 长度倍数 目的数据类型(可选)
TINYINT       SMALLINT       BIGSERIAL|SERIAL|INT1|TINYINT|INT2|INT|INTEGER|INT4|BIGINT|INT8|DECIMAL|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
TINYINT UNSIGNED       SMALLINT       BIGSERIAL|SERIAL|TINYINT|INT1|INT2|INT|INTEGER|INT4|BIGINT|INT8|DECIMAL|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
SMALLINT       SMALLINT       BIGSERIAL|SERIAL|TINYINT|INT1|INT2|INT|INTEGER|INT4|BIGINT|INT8|DECIMAL|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
SMALLINT UNSIGNED       INT       BIGSERIAL|SERIAL|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|BIGINT|INT8|DECIMAL|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
MEDIUMINT       INT       BIGSERIAL|SERIAL|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|BIGINT|INT8|DECIMAL|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
MEDIUMINT UNSIGNED       INT       BIGSERIAL|SERIAL|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|BIGINT|INT8|DECIMAL|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
INT       INT       BIGSERIAL|SERIAL|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|BIGINT|INT8|DECIMAL|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
INT UNSIGNED       BIGINT       BIGSERIAL|SERIAL|INT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|DECIMAL|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
BIGINT       BIGINT       BIGSERIAL|SERIAL|INT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|DECIMAL|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
BIGINT UNSIGNED       DECIMAL 2 0   BIGSERIAL|SERIAL|BIGINT|INT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
FLOAT       FLOAT8       DECIMAL|BIGINT|INT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT
DOUBLE       FLOAT8       DECIMAL|BIGINT|INT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT
DOUBLE UNSIGNED       FLOAT8       DECIMAL|BIGINT|INT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT
REAL       FLOAT8       DECIMAL|BIGINT|INT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT
DOUBLE PRECISION       FLOAT8       DECIMAL|BIGINT|INT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT
DECIMAL P<=15 S!=0   FLOAT8       DECIMAL|BIGINT|INT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT
DECIMAL P<=2 S=0   SMALLINT       DECIMAL|BIGINT|INT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
DECIMAL 2<P<=4 S=0   SMALLINT       DECIMAL|BIGINT|INT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
DECIMAL 4<P<=9 S=0   INT       DECIMAL|BIGINT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
DECIMAL 9<P<=18 S=0   BIGINT       DECIMAL|INT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
DECIMAL       DECIMAL       BIGINT|INT|SMALLINT|TINYINT|INT1|INT2|INTEGER|INT4|INT8|NUMERIC|NUMBER|FLOAT4|DOUBLE PRECISION|FLOAT8|FLOAT
BIT       BIT        
DATE       DATE       VARCHAR
DATETIME       TIMESTAMP 0     DATE|VARCHAR
TIMESTAMP       TIMESTAMP 0     VARCHAR
TIME       VARCHAR 1     TIME
YEAR       SMALLINT        
CHAR       CHAR       VARCHAR|TEXT|CLOB
VARCHAR     0<=L<=4000 VARCHAR       CHAR|TEXT|CLOB
VARCHAR     4001<=L<=8000 VARCHAR       CHAR|TEXT|CLOB
VARCHAR     8001<=L<=65535 CLOB       VARCHAR|CHAR|TEXT
BINARY       BINARY P      
VARBINARY     0<=L<=8000 VARBINARY        
VARBINARY     8001<=L<=65535 BLOB        
TINYBLOB       VARBINARY 255      
BLOB     0<=L<=8000 VARBINARY        
BLOB     8001<=L<=65535 BLOB        
MEDIUMBLOB       BLOB        
LONGBLOB       BLOB        
TINYTEXT       VARCHAR       CLOB|CHAR|TEXT
TEXT     0<=L<=8000 VARCHAR       CLOB|CHAR|TEXT
TEXT     8001<=L<=65535 CLOB       VARCHAR|CHAR|TEXT
MEDIUMTEXT       CLOB       VARCHAR|CHAR|TEXT
LONGTEXT       CLOB       VARCHAR|CHAR|TEXT
ENUM       VARCHAR        
SET       VARCHAR