These Adaptive Server Enterprise data types are not supported by Sybase IQ in this version:
nchar, nvarchar
unichar, univarchar, unitext
text
image
unsigned smallint
native Java data types
XML data type
Note the following:
Sybase IQ supports the Adaptive Server Enterprise text and image types via binary large object (BLOB) and character large object (CLOB) data types. For details, see Unstructured Data Analytics in Sybase IQ.
In Sybase Central, you can create columns with certain data types in the SYSTEM dbspace (catalog store) only. In the Create Table wizard, choose Create a Table in the System Store.
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.
