Not all Adaptive Server Enterprise data types are
supported.
These Adaptive Server Enterprise data types are not
currently supported by SAP Sybase IQ:
- date
- text
- nchar, nvarchar
- unichar, univarchar, unitext
- text
- image
- unsigned smallint
- native Java data types
- XML data type
Note the following:
- 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.