These Adaptive Server Enterprise data types are not supported by Sybase IQ in this version:
nchar, nvarchar
unichar, univarchar
text
image
unsigned smallint
long varchar
native Java data types
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 datatypes 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 datatypes such as TEXT and java.lang.Object. Selecting SYSTEM also enables Include/Exclude Java Class Datatypes, the third icon from the right in the Table Editor toolbar. Choose this icon to add these datatypes to the Data Type dropdown.
Sybase IQ does not support the Adaptive Server Enterprise data type TEXT, but you can insert data from an ASE database column of data type TEXT using the LOCATION syntax of the INSERT statement.
