Additional SQL data types for Informix

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

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

Informix 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.