|
Supported Data Types - ODBC Driver for SQL Server |
|
|
|
Supported Data Types - ODBC Driver for SQL Server |
|
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 |