|
BYTE |
RAW |
- |
|
BYTEINT |
NUMBER(3) |
- |
|
CHAR |
CHAR |
- |
|
CHARACTER |
CHAR |
- |
|
DATE |
CHAR(10) or DATE |
The conversion depends on the DateTimeFormat parameter in the ODBC DSN. Please refer to NCR's ODBC documentation |
|
DEC |
NUMBER(p[,s]) |
- |
|
DECIMAL |
NUMBER(p[,s]) |
- |
|
DOUBLE PRECISION |
FLOAT(49) |
- |
|
FLOAT |
FLOAT(49) |
- |
|
INT |
NUMBER(10) |
NUMBER range is -2,147,483,647 to 2,147,483,647 |
|
INTEGER |
NUMBER(10) |
NUMBER range is -2,147,483,647 to 2,147,483,647 |
|
INTERVAL |
Not supported |
- |
|
LONG VARCHAR |
LONG |
- |
|
NUMERIC |
NUMBER(p[,s]) |
- |
|
REAL |
FLOAT(49) |
- |
|
SMALLINT |
NUMBER(5) |
- |
|
TIME |
CHAR(8) or DATE |
The conversion depends on the DateTimeFormat parameter in the ODBC DSN. Please refer to NCR's ODBC documentation |
|
TIMESTAMP |
CHAR(23) or DATE |
The conversion depends on the DateTimeFormat parameter in the ODBC DSN. Please refer to NCR's ODBC documentation |
|
VARBYTE |
RAW |
VARBYTE is right padded. If the size is greater than 2000 it is truncated to RAW(2000) |
|
VARCHAR |
VARCHAR2 |
If the size is greater than 4000 it is truncated to VARCHAR2(4000) |
