The following table shows the acceptable source datatypes that the access service can convert into corresponding target destination datatypes.
Source datatypes |
Target datatypes |
||||
|---|---|---|---|---|---|
CHAR, VARCHAR, LONGVARCHAR, TEXT (CLOB), |
BIGINT, DECIMAL, DOUBLE FLOAT, INTEGER, MONEY, MONEY4, NUMERIC, REAL, SMALLINT, TINYINT |
DATETIME, DATETIME4, TIMESTAMP |
BINARY, VARBINARY, LONGVARBINARY, IMAGE (BLOB) |
BIT |
|
CHAR, VARCHAR, LONGVARCHAR, TEXT (CLOB) |
X |
X |
X |
X |
X |
BIGINT, DECIMAL, DOUBLE, FLOAT, INTEGER, MONEY, MONEY4, NUMERIC, REAL, SMALLINT, TINYINT |
X |
X |
|||
BINARY, VARBINARY, LONGVARBINARY, IMAGE (BLOB) |
X |
X |
|||
DATETIME, DATETIME4, TIMESTAMP |
X |
X |
|||
BIT |
X |
X |
X |
Datatypes resulting from this conversion are converted into actual datatypes in the target column, as shown in Table 9-2. If a column match is incompatible, the transfer ends with an error.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
