The following table contains the available data types for OLE DB-compliant databases supported by CONNX.
|
CONNX Data Type |
SQL Data Type |
Length |
VMS Equivalent Data Type |
Description |
|
Access Currency |
CURRENCY |
-1 |
|
|
|
Binary |
CHAR |
8 |
|
This date should not be used. It is here for backward compatibility. See VMS DATE/Time. This converts a VMS date into a 23-character string. |
|
Binary (Text) |
CHAR |
-1 |
|
|
|
OLEDB Date |
DATE |
6 |
|
16-byte Timestamp with no time information. |
|
OLEDB Decimal |
DECIMAL |
-1 |
|
4-byte number with precision and scale. |
|
OLEDB Double |
DOUBLE |
8 |
|
Double precision floating pint. |
|
OLEDB Number |
DECIMAL |
-1 |
|
4-byte number with precision and scale. |
|
OLEDB Real |
REAL |
4 |
|
Single precision floating point. |
|
OLEDB Time |
TIME |
16 |
|
16-byte Timestamp with no date information. |
|
OLEDB Timestamp |
TIMESTAMP |
16 |
|
16-byte Timestamp |
|
OLEDB Wstr |
UNICODE |
1-255 |
|
Unicode string |
|
Text (Right Space Padded) |
CHAR |
1-30000 |
Text Maxcim Yes/No |
Alphanumeric and symbols. (1-30000 chars); same as Text but with right space padding. |
|
Unsigned Byte |
TINYINT |
1 |
|
|
|
Unsigned Byte Double |
DOUBLE |
1 |
|
|
|
Unsigned Byte -> Decimal |
DECIMAL |
1 |
|
|
|
Unsigned Long |
INTEGER |
4 |
|
|