> ### Microsoft SQL Server

> The following table maps the ODBC data types that the ODBC driver supports to the Microsoft SQL Server:

> Table B-3. Mapping Data Types for Microsoft SQL Server to ODBC Data Types
> Microsoft SQL Server 2000, 2005 Data Type | ODBC Data Type
> --- | ---
> bigint | SQL_BIGINT
> bigint identity | SQL_BIGINT
> binary | SQL_BINARY
> bit | SQL_BIT
> char | SQL_CHAR1 SQL_WCHAR2
> datetime | SQL_DATETIME3 SQL_CHAR4
> decimal | SQL_DECIMAL
> decimal identity | SQL_DECIMAL
> float | SQL_FLOAT
> guid | SQL_BINARY
> image | SQL_LONGVARBINARY
> int | SQL_INTEGER
> int identity | SQL_INTEGER
> money | SQL_DECIMAL
> nchar | SQL_CHAR1 SQL_WCHAR2
> ntext | SQL_LONGVARCHAR1 SQL_WLONGVARCHAR2
> nvarchar(max) | SQL_LONGVARCHAR
> numeric | SQL_NUMERIC
> numeric identity | SQL_NUMERIC
> nvarchar | SQL_VARCHAR1 SQL_WVARCHAR2
> real | SQL_REAL
> smalldatetime | SQL_DATETIME3 SQL_CHAR4
> smallint | SQL_SMALLINT
> smallint identity | SQL_SMALLINT
> smallmoney | SQL_DECIMAL
> SQLVariant | SQL_BINARY
> sysname | SQL_VARCHAR1 SQL_WVARCHAR2
> text | SQL_LONGVARCHAR1 SQL_WVARCHAR2
> timestamp | SQL_BINARY
> tinyint | SQL_TINYINT
> tinyint identity | SQL_TINYINT
> uniqueidentifier | SQL_BINARY
> varbinary | SQL_VARBINARY
> varbinary(max) | SQL_LONGVARBINARY
> varchar | SQL_VARCHAR1 SQL_WVARCHAR2
> varchar(max) | SQL_LONGVARCHAR1

> 1Not present when DataSourceReportChar=False and ServiceCodePage=Database 2Only present whe ServiceCodePage=Database 3Only present when DataSourceFetchTimestampAsString=False 4Only present when DataSourceFetchTimestampAsString=True