Data Types

Table 14-3 shows how the Microsoft SQL Server data types are mapped to the standard ODBC data types. “Unicode Support” lists Microsoft SQL Server to Unicode data type mappings.

Table 14-3. Microsoft SQL Server Data Types 

SQL Server	ODBC
binary	SQL_BINARY
bigint 1	SQL_BIGINT
bit	SQL_BIT
char	SQL_CHAR
date 2	SQL_TYPE_DATE
datetime	SQL_TYPE_TIMESTAMP
datetime2 2	SQL_TYPE_TIMESTAMP
datetimeoffset 2 3	SQL_WVARCHAR
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
time 2 4	SQL_TYPE_TIMESTAMP
timestamp	SQL_VARBINARY
tinyint	SQL_TINYINT
tinyint identity	SQL_TINYINT
uniqueidentifier	SQL_GUID
varbinary	SQL_VARBINARY
varbinary(max) 5	SQL_LONGVARBINARY
varchar	SQL_VARCHAR
varchar(max) 5	SQL_LONGVARCHAR

---

1

Bigint supported on Windows driver only.

2

Supported only on Microsoft SQL Server 2008 and higher.

3

Datetimeoffset mapping changes based on the setting of the Fetch TSWTZ as Timestamp option.

4

Time mapping changes based on the setting of the Fetch TWFS as Time option.

5

Supported only on Microsoft SQL Server 2005 and higher.

See “Retrieving Data Type Information” for information about retrieving data types.