Character data compatibility differences exist between SAP Sybase IQ and Adaptive Server and SQL Anywhere.
The CHARACTER (n) alternative for CHAR is not supported in Adaptive Server.
SAP Sybase IQ does not support the NCHAR, NVARCHAR, UNICHAR, and UNIVARCHAR data types provided by Adaptive Server. 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, always specify a length for character data types.