Additional conversions for HCL OneDB

There are supported conversions between the additional HCL OneDB™ SQL data types for HCL OneDB and the HCL OneDB ODBC Driver C data types.

The HCL OneDB SQL data types, Collection, DISTINCT, Row, and Smart large object, support conversions between the following HCL OneDB ODBC driver C data types (fCType):
  • SQL_C_BINARY
  • SQL_C_BIT
  • SQL_C_CHAR
  • SQL_C_DATE
  • SQL_C_DOUBLE
  • SQL_C_FLOAT
  • SQL_C_LONG
  • SQL_C_SHORT
  • SQL_C_SLONG
  • SQL_C_SSHORT
  • SQL_C_STINYINT
  • SQL_C_TIMESTAMP
  • SQL_C_TINYINT
  • SQL_C_ULONG
  • SQL_C_USHORT
  • SQL_C_UTINYINT

The HCL OneDB SQL data type OPAQUE supports conversion between the SQL_C_BINARY and SQL_C_CHAR ODBC driver C data types (fCType). Use SQL_C_CHAR to access an OPAQUE value in the external format as a string. Use SQL_C_BINARY to access an OPAQUE value in the internal binary format.