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. The following table 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 |
