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 Large Objects Management in Sybase IQ.
In Sybase Central, the Table Editor allows you to create columns with certain data types in the SYSTEM dbspace (catalog store) only. Choose the Advanced Table Properties button (fourth from the left) on the toolbar, then select SYSTEM from the DB Space dropdown box. The Data Type dropdown will now include data types such as TEXT and java.lang.Object.
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 ASE database column of data type DATE, TEXT, UNSIGNED SMALLINT, NCHAR, NVARCHAR, UNICHAR, UNIVARCHAR, or UNITEXT, using the LOCATION syntax of the INSERT statement.
