> ## Documentation Index > Fetch the complete documentation index at: https://insightsoftware-preview.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # 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 TypeSQL 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.