Not all Adaptive Server Enterprise data types are supported.
date
text
nchar, nvarchar
unichar, univarchar, unitext
text
image
unsigned smallint
native Java data types
XML data type
SAP Sybase IQ supports the Adaptive Server Enterprise text and image types via binary large object (BLOB) and character large object (CLOB) data types.
SAP Sybase IQ does not support the Adaptive Server Enterprise data types DATE, TEXT, UNSIGNED SMALLINT, NCHAR, NVARCHAR, UNICHAR, UNIVARCHAR, or UNITEXT, but you can insert data from an Adaptive Server Enterprise database column of data type DATE, TEXT, UNSIGNED SMALLINT, NCHAR, NVARCHAR, UNICHAR, UNIVARCHAR, or UNITEXT, using the LOCATION syntax of the INSERT statement.