Avoidance in TEXT and BYTE columns

Partial characters are not a problem when you specify a column substring for a column of the TEXT or BYTE data type.

The database server avoids partial characters in TEXT and BYTE columns in the following way:
  • Because the database server interprets a BYTE column as a series of bytes, not characters, the splitting of multibyte characters as a result of the byte range that a column substring specifies is not an issue.

    A substring of a BYTE column returns the exact range of bytes that is specified and does not replace any bytes with white space characters.

  • The database server interprets a TEXT value as a character string.

    A substring from a TEXT column returns the exact range of bytes that is specified. Attempts to resolve partial characters in TEXT data are resource-intensive, but the database server does not replace any bytes with white space. For more information, see The TEXT data type.

Important: The processing and interpretation of TEXT and BYTE data are the responsibility of the client application, which must handle the possibility of partial characters in these operations.