热门搜索
分布式
数据库一体机
云数据库
建设银行
保险核心
密集交易
注册
达梦数据复制软件DMDRS数据类型映射关系：源数据库DM8到异构目标数据库（DM6/GBase 8s/openGauss/DB2/Doris等）
专栏/数+融合专栏/ 文章详情 /

达梦数据复制软件DMDRS数据类型映射关系：源数据库DM8到异构目标数据库（DM6/GBase 8s/openGauss/DB2/Doris等）

达梦数+数据融合软件（DMDF）产品团队 2026/07/16 254 1 0
摘要 介绍达梦数据复制软件DMDRS数据类型映射关系，包含源数据库DM8与异构目标数据库（DM6/GBase 8s/openGauss/DB2/Doris）

1 DM8到DM6

源数据库数据类型 目标数据库数据类型 精度策略 标度策略
CHAR CHAR CHECK_CHARSET NULL
NCHAR CHAR CHECK_CHARSET NULL
CHAR CHAR CHAR CHECK_CHARSET NULL
CHARACTER CHAR CHECK_CHARSET NULL
VARCHAR VARCHAR CHECK_CHARSET NULL
VARCHAR2 VARCHAR2 CHECK_CHARSET NULL
NVARCHAR2 VARCHAR CHECK_CHARSET NULL
NCHAR VARYING VARCHAR CHECK_CHARSET NULL
NUMERIC NUMERIC RESVD RESVD
DECIMAL DECIMAL RESVD RESVD
DEC DEC RESVD RESVD
NUMBER NUMBER RESVD RESVD
DEC MONEY 19 4
INTEGER INTEGER 10 0
INT INT 10 0
BIGINT BIGINT 19 0
TINYINT TINYINT 3 0
BYTE BYTE 3 0
SMALLINT SMALLINT 5 0
BINARY BINARY CHECK NULL
VARBINARY VARBINARY CHECK NULL
FLOAT 精度小于等于24：REAL/精度大于24：FLOAT 53 NULL
DOUBLE DOUBLE 53 NULL
REAL REAL NULL NULL
DOUBLE PRECISION DOUBLE PRECISION 53 NULL
BIT BIT 1 NULL
DATE DATE NULL NULL
TIME TIME RESVD RESVD
TIME WITH TIME ZONE TIME RESVD RESVD
TIMESTAMP TIMESTAMP RESVD RESVD
TIMESTAMP WITH TIME ZONE TIMESTAMP RESVD RESVD
TIMESTAMP WITH LOCAL TIME ZONE TIMESTAMP RESVD RESVD
INTERVAL YEAR TO MONTH INTERVAL YEAR TO MONTH RESVD NULL
INTERVAL YEAR INTERVAL YEAR RESVD NULL
INTERVAL MONTH INTERVAL MONTH RESVD NULL
INTERVAL DAY INTERVAL DAY RESVD NULL
INTERVAL DAY TO HOUR INTERVAL DAY TO HOUR RESVD NULL
INTERVAL DAY TO MINUTE INTERVAL DAY TO MINUTE RESVD NULL
INTERVAL DAY TO SECOND INTERVAL DAY TO SECOND RESVD RESVD
INTERVAL HOUR INTERVAL HOUR RESVD NULL
INTERVAL HOUR TO MINUTE INTERVAL HOUR TO MINUTE RESVD NULL
INTERVAL HOUR TO SECOND INTERVAL HOUR TO SECOND RESVD RESVD
INTERVAL MINUTE INTERVAL MINUTE RESVD NULL
INTERVAL MINUTE TO SECOND INTERVAL MINUTE TO SECOND RESVD RESVD
INTERVAL SECOND INTERVAL SECOND RESVD NULL
TIMESTAMP WITH TIME ZONE TIMESTAMP WITH TIME ZONE NULL RESVD
TIMESTAMP WITH LOCAL TIME ZONE TIMESTAMP WITH LOCAL TIME ZONE NULL RESVD
TEXT TEXT NULL NULL
CLOB CLOB NULL NULL
BLOB BLOB NULL NULL
IMAGE IMAGE NULL NULL
LONGVARBINARY LONGVARBINARY NULL NULL

2 DM8到GBase 8s

源数据库数据类型 目标数据库数据类型 精度策略 标度策略
CHAR CHAR CHECK NULL
CHARACTER CHAR CHECK NULL
VARCHAR（BFILE） 精度小于255：VARCHAR/精度大于等于255：LVARCHAR CHECK NULL
VARCHAR2 精度小于255：VARCHAR/精度大于等于255：LVARCHAR CHECK NULL
NUMERIC 精度小于等于32：DECIMAL/精度大于32：VARCHAR（50） RESVD RESVD
DECIMAL 精度小于等于32：DECIMAL/精度大于32：VARCHAR（50） RESVD RESVD
DEC 精度小于等于32：DECIMAL/精度大于32：VARCHAR（50） RESVD RESVD
NUMBER 精度小于等于32：DECIMAL/精度大于32：VARCHAR（50） RESVD RESVD
INTEGER INT8 10 0
INT INT8 10 0
BIGINT DECIMAL 19 0
TINYINT INTEGER 3 0
BYTE INTEGER 3 0
SMALLINT DECIMAL 5 0
BINARY BYTE CHECK NULL
VARBINARY BYTE CHECK NULL
FLOAT FLOAT 16 NULL
DOUBLE FLOAT 16 NULL
REAL REAL NULL NULL
DOUBLE PRECISION FLOAT 16 NULL
BIT BOOLEAN 1 NULL
DATE DATETIME YEAR TO DAY NULL RESVD
TIME VARCHAR 32 NULL
TIMESTAMP DATETIME YEAR TO FRACTION NULL RESVD（最大值5）
INTERVAL YEAR TO MONTH VARCHAR 32 NULL
INTERVAL YEAR VARCHAR 32 NULL
INTERVAL MONTH VARCHAR 32 NULL
INTERVAL DAY VARCHAR 32 NULL
INTERVAL DAY TO HOUR VARCHAR 32 NULL
INTERVAL DAY TO MINUTE VARCHAR 32 NULL
INTERVAL DAY TO SECOND VARCHAR 32 NULL
INTERVAL HOUR VARCHAR 32 NULL
INTERVAL HOUR TO MINUTE VARCHAR 32 NULL
INTERVAL HOUR TO SECOND VARCHAR 32 NULL
INTERVAL MINUTE VARCHAR 32 NULL
INTERVAL MINUTE TO SECOND VARCHAR 32 NULL
INTERVAL SECOND VARCHAR 32 NULL
TIME WITH TIME ZONE VARCHAR 48 NULL
TIMESTAMP WITH TIME ZONE VARCHAR 48 NULL
TIMESTAMP WITH LOCAL TIME ZONE VARCHAR 48 NULL
TEXT TEXT NULL NULL
LONG TEXT NULL NULL
LONGVARCHAR TEXT NULL NULL
BLOB BYTE NULL NULL
CLOB TEXT NULL NULL
IMAGE BYTE NULL NULL
LONGVARBINARY BYTE NULL NULL
CHAR BYTE 精度小于255：VARCHAR/精度大于等于255：LVARCHAR RESVD NULL
CHAR CHAR 精度小于255：VARCHAR/精度大于等于255：LVARCHAR RESVD NULL
CHAR VARCHAR 精度小于255：VARCHAR/精度大于等于255：LVARCHAR RESVD NULL
BOOL BOOLEAN 1 NULL
XDEC VARCHAR 32 NULL
DATETIME DATETIME YEAR TO SECOND NULL RESVD
DATETIME WITH TIME ZONE LVARCHAR NULL NULL
NCHAR NCHAR RESVD NULL
NVARCHAR2 NVARCHAR RESVD NULL
VARCHAR2 CHAR 精度小于255：VARCHAR/精度大于等于255：LVARCHAR RESVD NULL
VARCHAR CHAR 精度小于255：VARCHAR/精度大于等于255：LVARCHAR RESVD NULL
ROWID INT8 20 NULL
XMLTYPE LVARCHAR NULL NULL

3 DM8到openGauss

源数据库数据类型 目标数据库数据类型 精度策略 标度策略
CHAR CHAR CHECK_CHARSET NULL
CHARACTER CHAR CHECK_CHARSET NULL
VARCHAR（BFILE） VARCHAR CHECK_CHARSET NULL
VARCHAR2 VARCHAR CHECK_CHARSET NULL
NUMERIC NUMERIC RESVD RESVD
DECIMAL DECIMAL RESVD RESVD
DEC DECIMAL RESVD RESVD
NUMBER NUMERIC RESVD RESVD
INTEGER INTEGER NULL NULL
INT INTEGER NULL NULL
BIGINT BIGINT NULL NULL
TINYINT SMALLINT NULL NULL
BYTE SMALLINT NULL NULL
SMALLINT SMALLINT NULL NULL
BINARY BYTEA CHECK NULL
VARBINARY BYTEA CHECK NULL
FLOAT DOUBLE PRECISION NULL NULL
DOUBLE DOUBLE PRECISION NULL NULL
REAL REAL NULL NULL
DOUBLE PRECISION DOUBLE PRECISION NULL NULL
BIT BIT 1 NULL
DATE DATE NULL NULL
TIME TIME RESVD NULL
TIMESTAMP TIMESTAMP RESVD NULL
INTERVAL YEAR TO MONTH INTERVAL YEAR TO MONTH NULL RESVD
INTERVAL YEAR INTERVAL YEAR NULL RESVD
INTERVAL MONTH INTERVAL MONTH NULL RESVD
INTERVAL DAY INTERVAL DAY TO HOUR NULL RESVD
INTERVAL DAY TO HOUR INTERVAL DAY TO HOUR NULL RESVD
INTERVAL DAY TO MINUTE INTERVAL DAY TO MINUTE NULL RESVD
INTERVAL DAY TO SECOND INTERVAL HOUR NULL RESVD
INTERVAL HOUR INTERVAL HOUR NULL RESVD
INTERVAL HOUR TO MINUTE INTERVAL HOUR TO MINUTE NULL RESVD
INTERVAL HOUR TO SECOND INTERVAL HOUR TO SECOND NULL RESVD
INTERVAL MINUTE INTERVAL MINUTE NULL RESVD
INTERVAL MINUTE TO SECOND VARCHAR 32 NULL
INTERVAL SECOND INTERVAL SECOND NULL RESVD
TIME WITH TIME ZONE TIME WITH TIME ZONE NULL RESVD
TIMESTAMP WITH TIME ZONE TIMESTAMP WITH TIME ZONE NULL RESVD
TIMESTAMP WITH LOCAL TIME ZONE VARCHAR 48 NULL
TEXT TEXT NULL NULL
LONG TEXT NULL NULL
LONGVARCHAR TEXT NULL NULL
BLOB BYTEA NULL NULL
CLOB TEXT NULL NULL
IMAGE BYTEA NULL NULL
LONGVARBINARY BYTEA NULL NULL
CHAR BYTE CHAR CHECK_CHARSET NULL
CHAR CHAR CHAR CHECK_CHARSET NULL
CHAR VARCHAR VARCHAR CHECK_CHARSET NULL
BOOL BOOLEAN 1 NULL
XDEC VARCHAR 32 NULL
DATETIME TIMESTAMP NULL RESVD
DATETIME WITH TIME ZONE TIMESTAMP WITH TIME ZONE NULL RESVD
NCHAR CHAR CHECK_CHARSET NULL
NVARCHAR2 VARCHAR CHECK_CHARSET NULL
VARCHAR2 CHAR VARCHAR CHECK_CHARSET NULL
VARCHAR CHAR VARCHAR CHECK_CHARSET NULL
ROWID VARCHAR 20 NULL
XMLTYPE TEXT NULL NULL

4 DM8到DB2

源数据库数据类型 目标数据库数据类型 精度策略 标度策略
CHAR VARCHAR CHECK_CHARSET NULL
CHARACTER VARCHAR CHECK_CHARSET NULL
VARCHAR（BFILE） VARCHAR CHECK_CHARSET NULL
VARCHAR2 VARCHAR CHECK_CHARSET NULL
NUMERIC DECIMAL RESVD RESVD
DECIMAL DECIMAL RESVD RESVD
DEC DECIMAL RESVD RESVD
NUMBER DECIMAL RESVD RESVD
INTEGER INTEGER NULL NULL
INT INTEGER NULL NULL
BIGINT BIGINT NULL NULL
TINYINT DECIMAL 3 0
BYTE DECIMAL 3 0
SMALLINT SMALLINT NULL NULL
BINARY VARBINARY RESVD NULL
VARBINARY VARBINARY RESVD NULL
FLOAT REAL NULL NULL
DOUBLE DOUBLE NULL NULL
REAL REAL NULL NULL
DOUBLE PRECISION DOUBLE NULL NULL
BIT CHAR 1 NULL
DATE DATE NULL NULL
TIME TIME NULL NULL
TIMESTAMP TIMESTAMP RESVD NULL
INTERVAL YEAR TO MONTH VARCHAR 36 NULL
INTERVAL YEAR VARCHAR 36 NULL
INTERVAL MONTH VARCHAR 36 NULL
INTERVAL DAY VARCHAR 36 NULL
INTERVAL DAY TO HOUR VARCHAR 36 NULL
INTERVAL DAY TO MINUTE VARCHAR 36 NULL
INTERVAL DAY TO SECOND VARCHAR 36 NULL
INTERVAL HOUR VARCHAR 36 NULL
INTERVAL HOUR TO MINUTE VARCHAR 36 NULL
INTERVAL HOUR TO SECOND VARCHAR 36 NULL
INTERVAL MINUTE VARCHAR 36 NULL
INTERVAL MINUTE TO SECOND VARCHAR 36 NULL
INTERVAL SECOND VARCHAR 36 NULL
TIME WITH TIME ZONE VARCHAR 36 NULL
TIMESTAMP WITH TIME ZONE CHAR 36 NULL
TIMESTAMP WITH LOCAL TIME ZONE VARCHAR 36 NULL
TEXT CLOB NULL NULL
LONG CLOB NULL NULL
LONGVARCHAR CLOB NULL NULL
BLOB BLOB NULL NULL
CLOB CLOB NULL NULL
IMAGE BLOB NULL NULL
LONGVARBINARY BLOB NULL NULL
CHAR BYTE VARCHAR RESVD NULL
CHAR CHAR VARCHAR RESVD NULL
CHAR VARCHAR VARCHAR RESVD NULL
BOOL BOOLEAN 1 NULL
DATETIME CHAR 36 NULL
DATETIME WITH TIME ZONE CHAR 36 NULL
NCHAR CHAR RESVD NULL
NVARCHAR2 VARCHAR RESVD NULL
VARCHAR2 CHAR VARCHAR RESVD NULL
VARCHAR CHAR VARCHAR RESVD NULL
ROWID CHAR 20 NULL

5 DM8到Doris

源数据库数据类型 目标数据库数据类型 精度策略 标度策略
CHAR CHAR CHECK_CHARSET NULL
CHARACTER CHAR CHECK_CHARSET NULL
VARCHAR VARCHAR CHECK_CHARSET NULL
VARCHAR2 VARCHAR CHECK_CHARSET NULL
NUMERIC DECIMAL CHECK CHECK
DECIMAL DECIMAL CHECK CHECK
DEC DECIMAL CHECK CHECK
NUMBER DECIMAL CHECK CHECK
INTEGER INT NULL NULL
INT INT NULL NULL
BIGINT BIGINT NULL NULL
TINYINT TINYINT NULL NULL
BYTE TINYINT NULL NULL
SMALLINT SMALLINT NULL NULL
BINARY CHAR CHECK NULL
VARBINARY VARCHAR RESVD NULL
FLOAT DOUBLE NULL NULL
DOUBLE DOUBLE NULL NULL
REAL FLOAT NULL NULL
DOUBLE PRECISION DOUBLE NULL NULL
BIT BOOLEAN 1 NULL
DATE DATE NULL NULL
TIME VARCHAR 20 CHECK
TIMESTAMP DATETIME NULL CHECK
INTERVAL YEAR TO MONTH VARCHAR 40 NULL
INTERVAL YEAR VARCHAR 40 NULL
INTERVAL MONTH VARCHAR 40 NULL
INTERVAL DAY VARCHAR 40 NULL
INTERVAL DAY TO HOUR VARCHAR 40 NULL
INTERVAL DAY TO MINUTE VARCHAR 40 NULL
INTERVAL DAY TO SECOND VARCHAR 40 NULL
INTERVAL HOUR VARCHAR 40 NULL
INTERVAL HOUR TO MINUTE VARCHAR 40 NULL
INTERVAL HOUR TO SECOND VARCHAR 40 NULL
INTERVAL MINUTE VARCHAR 40 NULL
INTERVAL MINUTE TO SECOND VARCHAR 40 NULL
INTERVAL SECOND VARCHAR 40 NULL
TIME WITH TIME ZONE VARCHAR 40 NULL
TIMESTAMP WITH TIME ZONE VARCHAR 50 NULL
TIMESTAMP WITH LOCAL TIME ZONE VARCHAR 50 NULL
TEXT STRING NULL NULL
LONG STRING NULL NULL
LONGVARCHAR STRING NULL NULL
BLOB STRING NULL NULL
CLOB STRING NULL NULL
IMAGE STRING NULL NULL
LONGVARBINARY STRING NULL NULL
CHAR BYTE CHAR CHECK_CHARSET NULL
CHAR CHAR CHAR CHECK_CHARSET NULL
CHAR VARCHAR VARCHAR CHECK_CHARSET NULL
BOOL BOOLEAN NULL NULL
XDEC VARCHAR 32 NULL
DATETIME DATETIME NULL CHECK
DATETIME WITH TIME ZONE VARCHAR 50 NULL
NCHAR CHAR CHECK_CHARSET NULL
NVARCHAR2 VARCHAR CHECK_CHARSET NULL
VARCHAR2 CHAR VARCHAR CHECK_CHARSET NULL
VARCHAR CHAR VARCHAR CHECK_CHARSET NULL
ROWID VARCHAR 20 NULL
XMLTYPE STRING NULL NULL
上一篇：
达梦数据复制软件DMDRS搭建部署示例：源数据库DM8到目标数据库SQL Server一对一数据同步
评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服
logo
logo
logo
鄂Copyright © 达梦国产化应用创新实验室
达梦在线服务平台社区用户管理规范

鄂ICP备18017926号-1