Microsoft™ Access 2000 Data Types
The following tables show the correspondences of Microsoft™ Access to IBM® Lotus Enterprise Integrator® (LEI) and Domino® Enterprise Connection Services (DECS) data types for various types of activities.
- (p) - Indicates that if Allow Precision Loss is not enabled, then an error will be generated on the type match. Allowing precision loss is the default.
- (o) - Indicates that overflow checking will be performed when data is being transferred. If an overflow occurs and Truncate Data When Necessary is enabled, then the data is truncated; if not, an error is generated.
For more information about these tables, see chapter 3.
Execute
| Microsoft™ Access |
Lotus® Connector API (used by LEI and DECS) |
|---|---|
| BIT, YES/NO |
Int |
| NUMBER BYTE |
Int |
| NUMBER INTEGER |
Int |
| NUMBER LONG INTEGER, COUNTER, AUTONUMBER (AutoNumber is set by FieldSize to 4, or 16 if FieldSize is set to Replication ID) |
Int |
| NUMBER SINGLE |
Float |
| NUMBER DOUBLE |
Float |
| CURRENCY |
Currency |
| DATE/TIME |
Datetime |
| TEXT, VARCHAR |
Text (variable length, bound <= 255) |
| LONGTEXT, MEMO, Hyperlink |
Text (variable length, unbounded) |
| VARBINARY, BINARY |
Binary (variable length, bound <= 510) |
| LONGBINARY, OLE OBJECT |
Binary (variable length, unbounded) |
Fetch
| Microsoft™ Access |
Lotus® Connector API (used by LEI and DECS) |
|---|---|
| BIT, YES/NO |
Int |
| NUMBER BYTE |
Int |
| NUMBER INTEGER |
Int |
| NUMBER LONG INTEGER, COUNTER, AUTONUMBER (AutoNumber is set by FieldSize to 4, or 16 if FieldSize is set to Replication ID) |
Int |
| NUMBER SINGLE |
Float |
| NUMBER DOUBLE |
Float |
| CURRENCY |
Currency |
| DATE/TIME |
Datetime |
| TEXT, VARCHAR |
Text (variable length, bound <= 255) |
| LONGTEXT, MEMO, Hyperlink |
Text (variable length, unbounded) |
| VARBINARY, BINARY |
Binary (variable length, bound <= 510) |
| LONGBINARY, OLE OBJECT |
Binary (variable length, unbounded) |
Insert/Update
| Lotus® Connector API (used by LEI and DECS) |
Microsoft™ Access |
|---|---|
| Int |
BIT, YESNO, NUMBER BYTE(o), NUMBER INTEGER(o), COUNTER, NUMBER LONG INTEGER, AUTONUMBER |
| Float |
NUMBER SINGLE (p, o), NUMBER DOUBLE |
| Currency |
CURRENCY |
| Datetime |
DATETIME, DATE, TIME, |
| Text (variable length, bound <= 255) |
TEXT (o), VARCHAR (o) |
| Text (variable length, unbounded) |
LONGTEXT, MEMO, Hyperlink |
| Binary (variable length, bound <= 510) |
BINARY (o), VARBINARY (o) |
| Binary (variable length, unbounded) |
LONGBINARY, OLE OBJECT |
Create
| Lotus® Connector API (used by LEI and DECS) |
Microsoft™ Access |
|---|---|
| Int |
BIT, YESNO, NUMBER BYTE(o), NUMBER INTEGER(o), COUNTER, NUMBER LONG INTEGER, AUTONUMBER |
| Float |
NUMBER SINGLE (p, o), NUMBER DOUBLE |
| Currency |
CURRENCY |
| Datetime |
DATETIME |
| Text (variable length, bound <= 255) |
TEXT (o), VARCHAR (o) |
| Text (variable length, unbounded) |
LONGTEXT, MEMO, Hyperlink |
| Binary (variable length, bound <= 510) |
BINARY (o), VARBINARY (o) |
| Binary (variable length, unbounded) |
LONGBINARY, OLE OBJECT |