Data Types

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

This section discusses compatibility information for data types.

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