Datatypes

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

• Numeric Datatype
  The SybPreparedStatement extension supports the way Adaptive Server handles the NUMERIC datatype where precision (total digits) and scale (digits after the decimal) can be specified.
• Image Datatype
  jConnect has a TextPointer class with sendData methods for updating an image column in an Adaptive Server or SQL Anywhere database.
• Text Datatype
  In jConnect 3.0 and earlier versions, a TextPointer class is used with sendData methods for updating a text column in an Adaptive Server or SQL Anywhere database.
• Date and Time Datatypes
  jConnect for JDBC supports the 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 Adaptive Server datatypes supported by jConnect.