Data Types

Table 11-2 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 11-2. Microsoft SQL Server Data Types 

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

---

1

Supported only on Microsoft SQL Server 2008 and higher.

2

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

3

Supported only on Microsoft SQL Server 2005 and higher.

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