Fetch and insert VARCHAR data

When an application uses a character host variable to fetch or insert a VARCHAR value, must ensure that the character value fits into the host variable or database column. When calculates the length of a source item, it does not count trailing spaces. The following sections describe how performs the conversion of VARCHAR data to and from char, fixchar, and string character data types.

These conversions also apply to NVARCHAR data. For more information about the NVARCHAR data type, see the HCL OneDB™ GLS User's Guide.