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.

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_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 Onelake data types are exposed via custom type identifiers, as in the native Onelake connector:

• Geometry, Geography, and HierarchyID use custom type -151.
• XML uses custom type -152.