Adaptive Server Enterprise,
SQL Anywhere and SAP Sybase IQ treat data
types differently.
This section discusses compatibility information for data
types.
Note: Data types that are not included in this section are
currently supported by all three products.
Bit Data Type
Adaptive Server Enterprise, SQL Anywhere and SAP Sybase IQ support the BIT data type, with differences.
Character Data Type Compatibility
Adaptive Server Enterprise, SQL Anywhere and SAP Sybase IQ permit CHAR and VARCHAR data, but each product treats these types differently.
Binary Data Types
Binary data type support differs between Adaptive Server Enterprise, SQL Anywhere and SAP Sybase IQ.
Date, Time, Datetime, and Timestamp Data Types
Although Adaptive Server Enterprise, SQL Anywhere and SAP Sybase IQ all support some form of date and time data, there are some differences.
Numeric Data Types
Adaptive Server Enterprise, SQL Anywhere, and SAP Sybase IQ have different default precision and scale.
Text Data Type
Support for TEXT data differs between Adaptive Server Enterprise, SQL Anywhere, and SAP Sybase IQ.
Image Data Type
Support for IMAGE data differs between Adaptive Server Enterprise, SQL Anywhere, and SAP Sybase IQ.
Java Data Types
Adaptive Server Enterprise allows Java data types in the database. SQL Anywhere and SAP Sybase IQ do not.