Skip to content

ERR-52027 String data right-truncated#

Version#

All versions

Explanation#

Unable to select data.

Cause#

This error message is output when:

  1. the CHAR data type value returned from the SELECT statement is larger than the declared host variable.

  2. a parsing error occurs in the executed query due to NULL values or special characters.

Action#

  1. Connect to the database

  2. Check the table column size.

  3. Declare the host variable used in the statement with the length (column size + 1 byte).

  4. Check whether rpad was used in the statement where the error occurred.

  5. If so, rewrite the query.

Reference#

N/A