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) |