Tables C-5 to C-7 show data type correspondence (foreign DB: ORACLE).
Table C-5 Data type correspondence (foreign DB: ORACLE) (1/3)
Data type of ORACLE (Foreign DB) | Data type of HiRDB | |||||||
---|---|---|---|---|---|---|---|---|
SI | INT | DEC(m,n) 1 ![]() ![]() ![]() ![]() | SFLT or REAL1 | FLT or DP1 | CH(n) 1 ![]() ![]() | |||
NUMBER(p,s) p: Precision s: Scaling | s = 0 or omitted | p = * or omitted9 | M2 | R3 | M6, 7 | M | M | |
s = 0, omitted, or -28 ![]() ![]() | 1 ![]() ![]() | R4 | M4 | M6, 7 | M | M | ||
5 ![]() ![]() | R5 | M6, 7 | M | M | ||||
10 ![]() ![]() | R6, 7 | M | M | |||||
30 ![]() ![]() | M | M | ||||||
1 ![]() ![]() | 1 ![]() ![]() | R7, 8 | M | M | ||||
p![]() | M | M | ||||||
s![]() ![]() | M | M | ||||||
CHAR(n) | 1 ![]() ![]() | R1, 6 | ||||||
256 ![]() ![]() | ||||||||
VARCHAR2(n) | 1 ![]() ![]() | |||||||
256 ![]() ![]() | ||||||||
NCHAR(n) (2-byte fixed-width national character set) | 1 ![]() ![]() | |||||||
128 ![]() ![]() | ||||||||
NCHAR(n) (Variable-width national character set) | 1 ![]() ![]() | |||||||
256 ![]() ![]() | ||||||||
NVARCHAR2(n) (2-byte fixed-width national character set) | 1 ![]() ![]() | |||||||
128 ![]() ![]() | ||||||||
NVARCHAR2(n) (Variable-width national character set) | 1 ![]() ![]() | |||||||
256 ![]() ![]() | ||||||||
LONG(n) | 1 ![]() ![]() | |||||||
256 ![]() ![]() | ||||||||
32,001 ![]() ![]() | ||||||||
DATE | D4, 6 | |||||||
RAW(n) | 1 ![]() ![]() | |||||||
256 ![]() ![]() | ||||||||
RAW(n) | 1 ![]() ![]() | |||||||
256 ![]() ![]() | ||||||||
LONG RAW(n) | 1 ![]() ![]() | |||||||
256 ![]() ![]() | ||||||||
32,001 ![]() ![]() | ||||||||
ROWID | ||||||||
MLSLABEL | ||||||||
CLOB(n) | 1 ![]() ![]() | |||||||
2,000,000,000 ![]() ![]() | ||||||||
NCLOB(n) | 1 ![]() ![]() | |||||||
2,000,000,000 ![]() ![]() | ||||||||
BLOB(n) | 1 ![]() ![]() | |||||||
2,000,000,000 ![]() ![]() |
Table C-6 Data type correspondence (foreign DB: ORACLE) (2/3)
Data type of ORACLE (Foreign DB) | Data type of HiRDB | |||||||
---|---|---|---|---|---|---|---|---|
VCH (n) 1 ![]() ![]() | MCH (n) 1 ![]() ![]() | MVC (n) 1 ![]() ![]() | NCH (n) 1 ![]() ![]() | NVC (n) 1 ![]() ![]() | DATE | |||
NUMBER(p,s) p: Precision s: Scaling | s = 0 or omitted | p = * or omitted | ||||||
s = 0, omitted, or -28 ![]() ![]() | 1 ![]() ![]() | |||||||
5 ![]() ![]() | ||||||||
10 ![]() ![]() | ||||||||
30 ![]() ![]() | ||||||||
1 ![]() ![]() | 1 ![]() ![]() | |||||||
p![]() | ||||||||
s![]() ![]() | ||||||||
CHAR(n) | 1 ![]() ![]() | R2, 5 | ||||||
256 ![]() ![]() | ||||||||
VARCHAR2(n) | 1 ![]() ![]() | R1, 5 | R2, 5 | |||||
256 ![]() ![]() | ||||||||
NCHAR(n) (2-byte fixed-width national character set) | 1 ![]() ![]() | R5 | ||||||
128 ![]() ![]() | ||||||||
NCHAR(n) (Variable-width national character set) | 1 ![]() ![]() | R3, 5 | ||||||
256 ![]() ![]() | ||||||||
NVARCHAR2(n) (2-byte fixed-width national character set) | 1 ![]() ![]() | R5 | ||||||
128 ![]() ![]() | ||||||||
NVARCHAR2(n) (Variable-width national character set) | 1 ![]() ![]() | R5 | ||||||
256 ![]() ![]() | ||||||||
LONG(n) | 1 ![]() ![]() | R1, 4, 5 | R2, 4, 5 | |||||
256 ![]() ![]() | ||||||||
32,001 ![]() ![]() | ||||||||
DATE | R1 | |||||||
RAW(n) | 1 ![]() ![]() | |||||||
256 ![]() ![]() | ||||||||
LONG RAW(n) | 1 ![]() ![]() | |||||||
256 ![]() ![]() | ||||||||
32,001 ![]() ![]() | ||||||||
ROWID | ||||||||
MLSLABEL | ||||||||
CLOB(n) | 1 ![]() ![]() | |||||||
2,000,000,000 ![]() ![]() | ||||||||
NCLOB(n) | 1 ![]() ![]() | |||||||
2,000,000,000 ![]() ![]() | ||||||||
BLOB(n) | 1 ![]() ![]() | |||||||
2,000,000,000 ![]() ![]() |
Table C-7 Data type correspondence (foreign DB: ORACLE) (3/3)
Data type of ORACLE (Foreign DB) | Data type of HiRDB | ||||||
---|---|---|---|---|---|---|---|
TIME | TSTAMP(p) p = 0, 2, 4, or 6 | INTERVAL YEAR TO DAY | INTERVAL HOUR TO SECOND | BIN (n) 1 ![]() ![]() | |||
NUMBER(p,s) p: Precision s: Scaling | s = 0 or omitted | p = * or omitted | |||||
s = 0, omitted, or -28 ![]() ![]() | 1 ![]() ![]() | ||||||
5 ![]() ![]() | |||||||
10 ![]() ![]() | |||||||
30 ![]() ![]() | |||||||
1 ![]() ![]() | 1 ![]() ![]() | ||||||
p![]() | |||||||
s![]() ![]() | |||||||
CHAR(n) | 1 ![]() ![]() | ||||||
256 ![]() ![]() | |||||||
VARCHAR2(n) | 1 ![]() ![]() | ||||||
256 ![]() ![]() | |||||||
NCHAR(n) (2-byte fixed-width national character set) | 1 ![]() ![]() | ||||||
128 ![]() ![]() | |||||||
NCHAR(n) (Variable-width national character set) | 1 ![]() ![]() | ||||||
256 ![]() ![]() | |||||||
NVARCHAR2(n) (2-byte fixed-width national character set) | 1 ![]() ![]() | ||||||
128 ![]() ![]() | |||||||
NVARCHAR2(n) (Variable-width national character set) | 1 ![]() ![]() | ||||||
256 ![]() ![]() | |||||||
LONG(n) | 1 ![]() ![]() | ||||||
256 ![]() ![]() | |||||||
32,001 ![]() ![]() | |||||||
DATE | R2 | ||||||
RAW(n) | 1 ![]() ![]() | ||||||
256 ![]() ![]() | |||||||
LONG RAW(n) | 1 ![]() ![]() | R3, 4 | |||||
256 ![]() ![]() | |||||||
32,001 ![]() ![]() | |||||||
ROWID | |||||||
MLSLABEL | |||||||
CLOB(n) | 1 ![]() ![]() | ||||||
2,000,000,000 ![]() ![]() | |||||||
NCLOB(n) | 1 ![]() ![]() | ||||||
2,000,000,000 ![]() ![]() | |||||||
BLOB(n) | 1 ![]() ![]() | ||||||
2,000,000,000 ![]() ![]() |