Data Types
The Simba SQL Server ODBC Driver supports many common data formats, converting between SQL Server data types and SQL data types.
The table below lists the supported data type mappings.
| SQL Server Type | SQL Type |
|---|---|
|
BigInt |
SQL_BIGINT |
|
BigInt Identity |
SQL_BIGINT |
|
Binary |
SQL_BINARY |
|
Bit |
SQL_BIT |
|
Char |
SQL_CHAR |
|
Date |
SQL_TYPE_DATE |
|
DateTime |
SQL_TYPE_TIMESTAMP |
|
DateTime2 |
SQL_TYPE_TIMESTAMP |
|
DateTimeOffset |
SQL_SS_TIMESTAMPOFFSET |
|
Decimal |
SQL_DECIMAL |
|
Decimal() Identity |
SQL_DECIMAL |
|
Float |
SQL_FLOAT |
|
GUID |
SQL_GUID |
|
Image |
SQL_LONGVARBINARY |
|
Int |
SQL_INTEGER |
|
Int Identity |
SQL_INTEGER |
|
Money |
SQL_DECIMAL |
|
NChar |
SQL_WCHAR |
|
NText |
SQL_WLONGVARCHAR |
|
Numeric |
SQL_NUMERIC |
|
Numeric() Identity |
SQL_NUMERIC |
|
NVarChar |
SQL_WVARCHAR |
|
NVarChar(Max) |
SQL_WVARCHAR |
|
Real |
SQL_REAL |
|
RowVersion |
SQL_BINARY |
|
SmallDateTime |
SQL_TYPE_TIMESTAMP |
|
SmallInt |
SQL_SMALLINT |
|
SmallInt Identity |
SQL_INTEGER |
|
SmallMoney |
SQL_DECIMAL |
|
SysName |
SQL_WVARCHAR |
|
Text |
SQL_LONGVARCHAR |
|
Time |
SQL_SS_TIME2 |
|
TinyInt |
SQL_TINYINT |
|
TinyInt Identity |
SQL_TINYINT |
|
VarBinary |
SQL_VARBINARY |
|
VarBinary(Max) |
SQL_VARBINARY |
|
VarChar |
SQL_VARCHAR |
|
VarChar(Max) |
SQL_VARCHAR |
In addition, certain SQL Server data types are exposed via custom type identifiers, as in the native SQL Server connector:
- Geometry, Geography, and HierarchyID use custom type -151.
- XML uses custom type -152.