Data Types

Adaptive Server Enterprise, SQL Anywhere and Sybase IQ treat data types differently.

This section discusses compatibility information for data types.

• Bit Data Type
  Adaptive Server Enterprise, SQL Anywhere and Sybase IQ support the BIT data type, with differences.
• Character Data Types
  Adaptive Server Enterprise, SQL Anywhere and 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 Sybase IQ.
• Date, Time, Datetime, and Timestamp Data Types
  Although Adaptive Server Enterprise, SQL Anywhere and Sybase IQ all support some form of date and time data, there are some differences.
• Numeric Data Types
  Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ have different default precision and scale.
• Text Data Type
  Support for TEXT data differs between Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ.
• Image Data Type
  Support for IMAGE data differs between Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ.
• Java Data Types
  Adaptive Server Enterprise allows Java data types in the database. SQL Anywhere and Sybase IQ do not.