Supported Data Types - ODBC Driver for SAP ASE

Data Type Mapping

The Devart ODBC Driver for ASE supports all ASE data types.

The following table describes how the ASE data types are mapped to the ODBC data types.

ASE Data Types	ODBC Data Types
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