Characteristics of string arguments

String arguments in Db2 ODBC rely on conventions.

Length of string arguments
String arguments for both output and input have associated length arguments. You should always use a valid output length argument.
Nul-termination of strings
By default, character strings that Db2 ODBC return are terminated with a nul-terminator (hex 00), except for strings that are returned from the graphic and DBCLOB data types into SQL_C_CHAR application variables.
String truncation
If an output string does not fit into the buffer, Db2 ODBC truncates the string to the size of the buffer and writes the nul-terminator. The string data can be truncated on input or output by using the appropriate SQLSTATE.
Interpretation of strings
Db2 ODBC normally interprets string arguments in a case-sensitive manner and does not trim any spaces from the values.

Parent topic: Conceptual view of a Db2 ODBC application