When you retrieve data from the target database, the access service converts the target data to default Open Server datatypes for delivery to the client application. Table B-1 shows ODBC datatypes and the resulting Open Server datatypes.
ODBC datatype |
Open Server datatype |
|---|---|
SQL_CHAR |
CS_CHAR |
SQL_VARCHAR |
CS_VARCHAR |
SQL_LONGVARCHAR |
CS_TEXT |
SQL_DECIMAL |
CS_DECIMAL |
SQL_NUMERIC |
CS_NUMERIC |
SQL_SMALLINT |
CS_SMALLINT |
SQL_INTEGER |
CS_INTEGER |
SQL_REAL |
CS_REAL |
SQL_FLOAT |
CS_FLOAT |
SQL_DOUBLE |
CS_FLOAT |
SQL_BIT |
CS_BIT |
SQL_TINYINT |
CS_TINYINT |
SQL_BIGINT |
CS_NUMERIC |
SQL_BINARY |
CS_BINARY |
SQL_VARBINARY |
CS_VARBINARY |
SQL_LONGVARBINARY |
CS_IMAGE |
SQL_DATE |
CS_CHAR |
SQL_TIME |
CS_CHAR |
SQL_TIMESTAMP |
CS_CHAR |
SQL_INTERVAL |
CS_CHAR |
