Data Truncation Error

A data truncation error occurs when incoming data is too large to be stored. The error can occur for a number of reasons:

• In a Multi Select Picklist or Multi Checkbox field, the combination of selected values could be larger than the maximum storage size for the field.

The default maximum size is 32 characters. If all values are selected, the number of characters required for N labels is the sum of the sizes of all N labels plus N-1 commas.

• Even in a single-selection Picklist or Global Picklist, a value available for selection might be longer than the maximum storage size for the field.
• The combination of all fields defined in the record could be larger than the maximum size of a MySQL row (65,535 bytes).