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 Corresponding SQL and host variable data types, attempts to convert the data types. Similarly, if you try to insert a value from a host variable into a database column, might need to convert data types if the host variable and database column do not use the correspondences in Corresponding SQL and host variable data types. 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 converts between numeric and character data
- How converts floating-point numbers to strings
- How converts BOOLEAN values to characters
- How converts DATETIME and INTERVAL values
- How converts between VARCHAR columns and character data