Datatypes

Review the use of numeric, image, text, date, time, and char data.

• Numeric Datatype
  The SybPreparedStatement extension supports the way SAP Adaptive Server handles the NUMERIC datatype where precision (total digits) and scale (digits after the decimal) can be specified.
• Image Datatype
  SAP jConnect has a TextPointer class with sendData methods for updating an image column in an SAP Adaptive Server or SAP SQL Anywhere database.
• Text Datatype
  In SAP jConnect 3.0 and earlier versions, a TextPointer class is used with sendData methods for updating a text column in an SAP Adaptive Server or SAP SQL Anywhere database.
• Date and Time Datatypes
  SAP jConnect for JDBC supports the SAP Adaptive Server datetime, smalldatetime, bigdatetime, bigtime, date, and time datatypes:
• Char, Varchar, Text, and GetByte Datatypes
  Do not use rs.getByte on a char, univarchar, unichar, varchar, or text field unless the data is hex, octal, or decimal.
• Other Supported Datatypes
  Review other SAP Adaptive Server datatypes supported by SAP jConnect.