The tables below show which Sybase IQ data types are compatible with Adaptive Server Enterprise data types.
Here are some general rules:
Sybase IQ character string types accept any Adaptive Server Enterprise character string type.
Sybase IQ exact numeric types accept any Adaptive Server Enterprise number types. However, if the 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).
Sybase IQ date/time types accept any Adaptive Server Enterprise date/time types.
