Level 1 | Converts spaces in literals, embedded variables, and ? parameter data in a data manipulation SQL as follows:
- If a character string literal is considered a national character string literal, two single-byte spaces are converted into a double-byte space. If a single-byte space appears by itself, it is not converted.
- If a character string literal is considered a mixed character string literal, a double-byte space is converted into two single-byte spaces.
- When data is being stored into a national character string-type string or is being compared with a national character string-type value expression, two single-byte spaces in an embedded variable or ? parameter are converted into a double-byte space. If a single-byte space appears by itself, it is not converted.
- When data is being stored into a mixed character string-type string or is being compared with a mixed character string-type value expression, a double-byte space in an embedded variable or ? parameter is converted into two single-byte spaces.
|