Features
Data types
The Simba OneLake ODBC Connector supports many common data formats, converting between Onelake data types and SQL data types.
The table below lists the supported data type mappings.
In addition, certain Onelake data types are exposed via custom type identifiers, as in the native Onelake connector:
| Onelake 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_WVARCHARunity |
| 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 |
- Geometry, Geography, and HierarchyID use custom type -151.
- XML uses custom type -152.