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 |