Oracle datatypes are converted to the Open Client datatypes when in passthrough mode.
Oracle Datatype |
Open Client Datatype Number_mode=0 |
Open Client Datatype Number_mode=1 |
Open Client Datatype Number_mode=2 |
|---|---|---|---|
number(1,0) |
tinyint |
tinyint |
numeric (1,0) |
number(2,0) |
tinyint |
tinyint |
numeric (2,0) |
number(3,0) |
smallint |
smallint |
numeric (3,0) |
number(4,0) |
smallint |
smallint |
numeric (4,0) |
number(5,0) |
int |
int |
numeric (5,0) |
number(p,0) where 6 <= p <= 9 |
int |
int |
numeric (p,0) |
number(p,0) where 10 <= p <= 38 |
numeric (p,0) |
numeric (p,0) |
numeric (p,0) |
number(p,s) where 1 <= p <= 38 and 1 <= s <= 38 |
numeric (p,s) |
numeric (p,s) |
numeric (p,s) |