|
SQL Server
|
ODBC
|
|
binary
|
SQL_BINARY
|
|
bigint
|
SQL_BIGINT
|
|
bigint identity
|
SQL_BIGINT
|
|
bit
|
SQL_BIT
|
|
char
|
SQL_CHAR
|
|
date1
|
SQL_TYPE_DATE
|
|
datetime
|
SQL_TYPE_TIMESTAMP
|
|
datetime22
|
SQL_TYPE_TIMESTAMP
|
|
decimal
|
SQL_DECIMAL
|
|
decimal() identity
|
SQL_DECIMAL
|
|
float
|
SQL_FLOAT
|
|
image
|
SQL_LONGVARBINARY
|
|
int
|
SQL_INTEGER
|
|
int identity
|
SQL_INTEGER
|
|
money
|
SQL_DECIMAL
|
|
numeric
|
SQL_NUMERIC
|
|
numeric() identity
|
SQL_NUMERIC
|
|
real
|
SQL_REAL
|
|
smalldatetime
|
SQL_TYPE_TIMESTAMP
|
|
smallint
|
SQL_SMALLINT
|
|
smallint identity
|
SQL_SMALLINT
|
|
smallmoney
|
SQL_DECIMAL
|
|
text
|
SQL_LONGVARCHAR
|
|
SQL_TYPE_TIMESTAMP
|
|
|
timestamp
|
SQL_BINARY
|
|
tinyint
|
SQL_TINYINT
|
|
tinyint identity
|
SQL_TINYINT
|
|
uniqueidentifier
|
SQL_GUID
|
|
varbinary
|
SQL_VARBINARY
|
|
varbinary(max)5
|
SQL_LONGVARBINARY
|
|
varchar
|
SQL_VARCHAR
|
|
varchar(max)6
|
SQL_LONGVARCHAR
|
