|
DB2 Data Type |
Access Data Type |
|
SMALLINT |
Integer |
|
INTEGER |
Long Integer |
|
REAL |
Single |
|
DOUBLE |
Double |
|
BIGINT |
Double |
|
CHARACTER or VARCHAR |
Text or Memo when length exceeds 255 |
|
LONG VARCHAR |
Memo |
|
CLOB |
Text or Memo when length exceeds 255 |
|
BLOB |
Binary or Long Binary when length exceeds 255 |
|
CHARACTER or VARCHAR FOR BIT DATA |
Binary or Long Binary when length exceeds 255 |
|
LONG VARCHAR FOR BIT DATA |
Long Binary |
|
DATE or TIME or TIMESTAMP |
DateTime |
|
DATALINK |
|
|
REFERENCE |
Binary |
|
DISTINCT TYPE |
DB2 base type converted as shown in this table |