Tables C-3 and C-4 show data type correspondence (foreign DB: XDM/RD E2)
Table C-3 Data type correspondence (Foreign DB: XDM/RD E2)(1/2)
Data type of XDM/RD E2 (Foreign DB) | Data type of HiRDB | ||||||||
---|---|---|---|---|---|---|---|---|---|
SMALLINT | INTEGER | DECIMAL(m,n) 1 ![]() ![]() ![]() ![]() | SMALLFLTor REAL4 | FLOAT or DOUBLE PRECISION4 | CHAR(n) 1 ![]() ![]() | VARCHAR(n) 1 ![]() ![]() | MCHAR(n) 1 ![]() ![]() | MVARCHAR(n) 1 ![]() ![]() | |
SMALLINT | R | ||||||||
INTEGER | R | ||||||||
DECIMAL(p,s) 1 ![]() ![]() 0 ![]() ![]() | R1, 5, 6 | ||||||||
LARGE DECIMAL(p,s) or NUMERIC(p,s) 1 ![]() ![]() 0 ![]() ![]() | R1, 6 | ||||||||
SMALLFLT or REAL | R | ||||||||
FLOAT or DOUBLE PRECISION | R | ||||||||
CHAR(n) 1 ![]() ![]() | R7 | ||||||||
CHAR(n) 256 ![]() | |||||||||
VARCHAR(n) 1 ![]() ![]() | R7 | ||||||||
VARCHAR(n) 256 ![]() | |||||||||
LONG VARCHAR(n) 1 ![]() ![]() | R2, 7 | ||||||||
LONG VARCHAR(n) 256 ![]() | |||||||||
MCHAR(n) 1 ![]() ![]() | R7 | ||||||||
MCHAR(n) 256 ![]() | |||||||||
MVARCHAR(n) 1 ![]() ![]() | R7 | ||||||||
MVARCHAR(n) 256 ![]() | |||||||||
LONG MVARCHAR(n) 1 ![]() ![]() | R2, 7 | ||||||||
LONG MVARCHAR(n) 256 ![]() | |||||||||
NCHAR(n) 1 ![]() ![]() | |||||||||
NCHAR(n) 128 ![]() | |||||||||
NVARCHAR(n) 1 ![]() ![]() | |||||||||
NVARCHAR(n) 128 ![]() | |||||||||
LONG NVARCHAR(n) 1 ![]() ![]() | |||||||||
LONG NVARCHAR(n) 128 ![]() | |||||||||
DATE | |||||||||
TIME | |||||||||
TIME(p) p = 0, 2, 4, or 6 | |||||||||
TIMESTAMP | R3, 7 | ||||||||
TIMESTAMP(p) p = 0, 2, 4, or 6 | R3, 7 | ||||||||
INTERVAL YEAR TO DAY | |||||||||
INTERVAL HOUR TO SECOND | |||||||||
INTERVAL HOUR TO SECOND(p) p = 0, 2, 4, or 6 | |||||||||
BLOB |
Table C-4 Data type correspondence (Foreign DB: XDM/RD E2)(2/2)
Data type of XDM/RD E2 (foreign DB) | Data type of HiRDB | |||||||
---|---|---|---|---|---|---|---|---|
NCHAR(n) 1 ![]() ![]() | NVARCHAR(n) 1 ![]() ![]() | DATE | TIME | TIMESTAMP(p) p = 0, 2, 4, or 6 | INTERVAL YEAR TO DAY | INTERVAL HOUR TO SECOND | BINARY(n) 1 ![]() ![]() | |
SMALLINT | ||||||||
INTEGER | ||||||||
DECIMAL(p,s) 1 ![]() ![]() 0 ![]() ![]() | ||||||||
LARGE DECIMAL(p,s) or NUMERIC(p,s) 1 ![]() ![]() 0 ![]() ![]() | ||||||||
SMALLFLT or REAL | ||||||||
FLOAT or DOUBLE PRECISION | ||||||||
CHAR(n) 1 ![]() ![]() | ||||||||
CHAR(n) 256 ![]() | ||||||||
VARCHAR(n) 1 ![]() ![]() | ||||||||
VARCHAR(n) 256 ![]() | ||||||||
LONG VARCHAR(n) 1 ![]() ![]() | ||||||||
LONG VARCHAR(n) 256 ![]() | ||||||||
MCHAR(n) 1 ![]() ![]() | ||||||||
MCHAR(n) 256 ![]() | ||||||||
MVARCHAR(n) 1 ![]() ![]() | ||||||||
MVARCHAR(n) 256 ![]() | ||||||||
LONG MVARCHAR(n) 1 ![]() ![]() | ||||||||
LONG MVARCHAR(n) 256 ![]() | ||||||||
NCHAR(n) 1 ![]() ![]() | R4 | |||||||
NCHAR(n) 128 ![]() | ||||||||
NVARCHAR(n) 1 ![]() ![]() | R4 | |||||||
NVARCHAR(n) 128 ![]() | ||||||||
LONG NVARCHAR(n) 1 ![]() ![]() | R1, 4 | |||||||
LONG NVARCHAR(n) 128 ![]() | ||||||||
DATE | R | |||||||
TIME | R | |||||||
TIME(p) p = 0, 2, 4,or 6 | R2 | |||||||
TIMESTAMP | ||||||||
TIMESTAMP(p) p = 0, 2, 4, or 6 | ||||||||
INTERVAL YEAR TO DAY | R | |||||||
INTERVAL HOUR TO SECOND | R | |||||||
INTERVAL HOUR TO SECOND(p) p = 0, 2, 4, or 6 | R3 | |||||||
BLOB |