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.
For dates in the first 9 days of a month, Adaptive Server Enterprise supports a blank or zero for the first digit; IQ supports a zero and a blank.
To ensure accuracy in dates, follow the recommendation in the Adaptive Server Enterprise Reference Manual to use leading zeros for single-digit years, months, and days.
If your Adaptive Server Enterprise dates include a blank first digit for the date, and you must use bcp out to export such data,
