Datatype Conversion

The RAPCache and RAPStore subscribers attempt automatic datatype conversion if the datatypes are compatible and no loss of precision occurs.

Automatic datatype conversion occurs between the RAP Data Stream (RDS) datatypes used to transfer messages between the publisher and subscriber sides and the database column datatypes used to store the information.

• Supported Datatypes
  Sybase RAP supports integer (signed and unsigned), numeric and decimal, date, datetime, and character datatypes.
• Unsupported Datatypes
  Sybase RAP does not support large object binary or text, money, float, char or varchar, and bit datatypes.
• Integer Conversions
  The available integer conversions depend on the integer type.
• Date and Time Conversions
  The available date and time conversions depend on the datatype.
• Lookup Tables
  The lookup tables are loaded once during initialization, and contain the lookup data.
• Recommended RDS Datatype to SQL Datatype Mappings
  Use the RDS datatype to SQL datatype mappings table to map the available RDS datatypes to the indicated database column types for optimal performance.
• Numeric Conversions
  The available numeric conversions depend on the datatype characteristics.

---

Created March 26, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com