The Expression Handler has the following behavior relative to the processing of spaces:
-
VARCHAR data is retrieved and replicated with no editing done on any of the leading or trailing spaces that were updated into the original source data values.
-
You can insert in a VARCHAR data value, a string that is zero length.
-
For CHAR data (either EBCDIC, ASCII, or Unicode), the product generally, by default, trims all trailing spaces.
-
If a CHAR value is ALL spaces, then in general, the product retrieves and replicates 1 space as a “place holder” for this situation.