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