Supported Data Types

For TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio), DataDirect database drivers support different data types depending on the database conditions.

Note: If you select a database that contains data of the BIT type, the BIT data cannot be sent using TIBCO BusinessWorks. In Java, the smallest data type, other than Boolean, are bytes. Generally, a byte requires 8 bits of space to be stored. So the bit column in the database cannot be less than 8 bits of space.
  • DB2
    The following DB2 data types are supported by DataDirect database drivers:
  • Microsoft SQL Server
    The following Microsoft SQL Server data types are supported by DataDirect database drivers:
  • MySQL
    The following MySQL data types are supported by DataDirect Database dirvers:
  • Oracle
    The following Oracle data types are supported by DataDirect database drivers:
  • PostgreSQL
    The following PostgreSQL data types are supported by DataDirect database drivers:
  • Sybase and Sybase Adaptive Server Anywhere
    The following Sybase data types are supported by DataDirect database drivers:
  • Teradata
    The following Teradata data types are supported by DataDirect database drivers: