ODBC Driver for SQL Server

Supported Data Types - ODBC Driver for SQL Server

Data Type Mapping

The Devart ODBC Driver for SQL Server supports all SQL Server data types.

The following table describes how the SQL Server data types are mapped to the ODBC data types.

SQL Server Data Types ODBC Data Types

tinyint

tinyint identity

SQL_TINYINT

smallint

smallint identity

SQL_SMALLINT

int

int identity

SQL_INTEGER

bigint

bigint identity

SQL_BIGINT

decimal

money

smallmoney

decimal() identity

SQL_DECIMAL

numeric

numeric() identity

SQL_NUMERIC

char

SQL_CHAR
nchar SQL_WCHAR

varchar

SQL_VARCHAR
nvarchar SQL_WVARCHAR

sysname

SQL_WVARCHAR

text

SQL_LONGVARCHAR
ntext SQL_WLONGVARCHAR

binary

timestamp

SQL_BINARY

datetimeoffset

time

datetime2

datetime

smalldatetime

SQL_TYPE_TIMESTAMP
varbinary SQL_VARBINARY
xml SQL_XML
sql_variant SQL_VARIANT
uniqueidentifier SQL_GUID
bit SQL_BIT
float SQL_FLOAT
image SQL_LONGVARBINARY
real SQL_REAL
date SQL_TYPE_DATE
© 2015-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback