Additional SQL data types for HCL OneDB

View the values for the precision, scale, length, and display size for additional HCL OneDB™ ODBC Driver SQL data types.

The following table describes the precision, scale, length, and display size for the HCL OneDB ODBC Driver SQL data types for HCL OneDB.


HCL OneDB ODBC driver sql data type (fSqlType)	Description
SQL_IFMX_UDT_BLOB	Precision Variable value. To determine this value, call a function that returns the precision for a column. Scale Not applicable. A function that returns the scale for a column returns -1 for this data type. Length Variable value. To determine this value, call a function that returns the length for a column. Display size Variable value. To determine this value, call a function that returns the display size for a column.
SQL_IFMX_UDT_CLOB	Precision Variable value. To determine this value, call a function that returns the precision for a column. Scale Not applicable. A function that returns the scale for a column returns -1 for this data type. Length Variable value. To determine this value, call a function that returns the length for a column. Display size Variable value. To determine this value, call a function that returns the display size for a column.
SQL_INFX_UDT_FIXED	Precision Variable value. To determine this value, call a function that returns the precision for a column. Scale Not applicable. A function that returns the scale for a column returns -1 for this data type. Length Variable value. To determine this value, call a function that returns the length for a column. Display size Variable value. To determine this value, call a function that returns the display size for a column.
SQL_INFX_UDT_VARYING	Precision Variable value. To determine this value, call a function that returns the precision for a column. Scale Not applicable. A function that returns the scale for a column returns -1 for this data type. Length Variable value. To determine this value, call a function that returns the length for a column. Display size Variable value. To determine this value, call a function that returns the display size for a column.