Part 2: The 32-Bit/64-Bit Drivers : The SQL Server Legacy Wire Protocol Driver : Data Types

Data Types
The following table 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.

1
Bigint supported on Windows driver only.

2
Supported only on Microsoft SQL Server 2008 and higher.

3
Supported only on Microsoft SQL Server 2008 and higher.

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

5
Supported only on Microsoft SQL Server 2008 and higher.

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

7
Supported only on Microsoft SQL Server 2005 and higher.

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

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.