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 |