Fetch and insert with host variables
If you try to fetch a value from a database column into a host variable that you do not declare according to the correspondence shown in Table 1, IBM® Informix® ESQL/C attempts to convert the data types. Similarly, if you try to insert a value from a host variable into a database column, Informix ESQL/C might need to convert data types if the host variable and database column do not use the correspondences in Table 1. Informix ESQL/C converts the data types only if the conversion is meaningful.
This section provides the following information about
data conversion for fetching and inserting values with host variables:
- How Informix ESQL/C converts between numeric and character data
- How Informix ESQL/C converts floating-point numbers to strings
- How Informix ESQL/C converts BOOLEAN values to characters
- How Informix ESQL/C converts DATETIME and INTERVAL values
- How Informix ESQL/C converts between VARCHAR columns and character data