ERR-52027 String data right-truncated#
Version#
All versions
Explanation#
Unable to select data.
Cause#
This error message is output when:
-
the CHAR data type value returned from the SELECT statement is larger than the declared host variable.
-
a parsing error occurs in the executed query due to NULL values or special characters.
Action#
-
Connect to the database
-
Check the table column size.
-
Declare the host variable used in the statement with the length (column size + 1 byte).
-
Check whether rpad was used in the statement where the error occurred.
-
If so, rewrite the query.
Reference#
N/A