Character data compatibility differences exist between Sybase IQ and Adaptive Server Enterprise and SQL Anywhere.
The CHARACTER (n) alternative for CHAR is not supported in Adaptive Server Enterprise.
Sybase IQ does not support the NCHAR, NVARCHAR, UNICHAR, and UNIVARCHAR data types provided by Adaptive Server Enterprise. Sybase IQ supports Unicode in the CHAR and VARCHAR data types.
Sybase IQ supports a longer LONG VARCHAR data type than SQL Anywhere. See Unstructured Data Analytics in Sybase IQ.
For compatibility between Sybase IQ and Adaptive Server Enterprise, always specify a length for character data types.