Binary string assignment
Binary string assignment involves assignment at both the storage and the retrieval of binary strings.
- Storage assignment:
- The length of a string that is assigned
to a column or transition variable must not be greater than the length attribute of the column or
parameter. If the string is longer than the length attribute of that column or transition variable,
an error is returned.
When the string is assigned to a fixed-length binary string column or parameter of a function or procedure, and the length of the string is less than the length attribute of that column or parameter, the string is padded to the right with the necessary number of binary zeros.
- Retrieval assignment:
- The length of a string that is assigned to a variable can be greater than the length attribute of the variable. When a string is assigned to a variable and the string is longer than the length attribute of the variable, the string is truncated on the right by the necessary number of bytes. When this occurs, a warning is returned.