Supported data types

Devart ODBC Driver for ASE supports all ASE data types.

The following table describes the mapping between the ASE and ODBC data types.

ASE data type	ODBC data type
`tinyint` `tinyint identity`	`SQL_TINYINT`
`smallint` `smallint identity` `usmallint`	`SQL_SMALLINT`
`int` `int identity` `uint`	`SQL_INTEGER`
`bigint` `bigint identity` `ubigint`	`SQL_BIGINT`
`decimal` `money` `smallmoney` `decimal() identity`	`SQL_DECIMAL`
`numeric` `numeric() identity`	`SQL_NUMERIC`
`char` `nchar`	`SQL_CHAR`
`varchar` `nvarchar`	`SQL_VARCHAR`
`sysname` `univarchar`	`SQL_WVARCHAR`
`text` `ntext`	`SQL_LONGVARCHAR`
`binary` `timestamp`	`SQL_BINARY`
`datetimeoffset` `datetime2` `datetime` `smalldatetime`	`SQL_TYPE_TIMESTAMP`
`unichar`	`SQL_WCHAR`
`unitext`	`SQL_WLONGVARCHAR`
`varbinary`	`SQL_VARBINARY`
`time`	`SQL_TYPE_TIME`
`xml`	`SQL_XML`
`sql_variant`	`SQL_VARIANT`
`uniqueidentifier`	`SQL_GUID`
`bit`	`SQL_BIT`
`float`	`SQL_DOUBLE`
`image`	`SQL_LONGVARBINARY`
`real`	`SQL_REAL`
`date`	`SQL_TYPE_DATE`