An access service transforms Transact-SQL datatypes to ODBC datatypes.
Transact-SQL Datatype |
Primary ODBC Datatype |
Secondary ODBC Datatype |
Final ODBC Datatype |
---|---|---|---|
Tinyint |
SQL_TINYINT |
SQL_SMALLINT |
SQL_INTEGER |
Smallint |
SQL_SMALLINT |
SQL_INTEGER |
SQL_INTEGER |
Int |
SQL_INTEGER |
SQL_INTEGER |
SQL_INTEGER |
Numeric |
SQL_NUMERIC |
SQL_DECIMAL |
SQL_FLOAT |
Decimal |
SQL_DECIMAL |
SQL_NUMERIC |
SQL_FLOAT |
Float |
SQL_FLOAT |
SQL_DOUBLE |
SQL_CHAR |
Double Precision |
SQL_DOUBLE |
SQL_FLOAT |
SQL_FLOAT |
Real |
SQL_REAL |
SQL_FLOAT |
SQL_FLOAT |
Smallmoney |
SQL_DECIMAL |
SQL_NUMERIC |
SQL_FLOAT |
Money |
SQL_DECIMAL |
SQL_NUMERIC |
SQL_FLOAT |
Smalldatetime |
TIMESTAMP |
SQL_CHAR |
SQL_CHAR |
Datetime |
TIMESTAMP |
SQL_CHAR |
SQL_CHAR |
Char |
SQL_CHAR |
SQL_CHAR |
SQL_CHAR |
Varchar |
SQL_VARCHAR |
SQL_VARCHAR |
SQL_VARCHAR |
Nchar |
1 (SQL_CHAR(2n)) |
SQL_CHAR |
SQL_CHAR |
Nvarchar |
12 (SQL_VARCHAR(2n)) |
SQL_VARCHAR |
SQL_VARCHAR |
Text |
SQL_LONGVARCHAR |
SQL_VARCHAR |
SQL_VARCHAR |
Binary |
SQL_BINARY |
SQL_VARBINARY |
SQL_CHAR |
Varbinary |
SQL_VARBINARY |
SQL_LONGVARBINARY |
SQL_VARCHAR |
Image |
SQL_LONGVARBINARY |
SQL_LONGVARCHAR |
SQL_VARCHAR |
Bit |
SQL_BIT |
SQL_CHAR |
SQL_CHAR |