Some SAP Sybase IQ data types are compatible with Adaptive Server Enterprise data types.
SAP Sybase IQ character string types accept any Adaptive Server Enterprise character string type.
SAP Sybase IQ exact numeric types accept any Adaptive Server Enterprise number types. However, if the SAP Sybase IQ data type holds a smaller amount of data than the Adaptive Server Enterprise type, the value converts to a NULL (for example, when inserting data from the underlying database into tables).
SAP Sybase IQ date/time types accept any Adaptive Server Enterprise date/time types.