ODBC Driver for SAP Sybase Adaptive Server Enterprise

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
© 2015-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback