Field_Type_Aux

The Pervasive.SQL non standard type of the column.

Supported By

DataFlex Pervasive.SQL Driver

Value

LSTRING2, DFBCD

Associated Attribute

None

Remarks

This can be used to specify certain non-standard data types and is typically used for DataFlex for Btrieve converted data tables that use non-standard field types. Currently implemented are LSTRING2 and DFBCD.

The LSTRING2 type can be used for TEXT fields in tables that have been converted with the  for Btrieve product. This field type stores the length of a text in the first two bytes followed by the actual text.

The DFBCD type is also being used by DataFlex for Btrieve converted data for numeric fields that exceeds the maximum number of digits of 21 for Pervasive.SQL numeric fields.

See Also

Column Keywords