Difference between revisions of "Data Truncation Error"

Revision as of 22:38, 2 April 2014

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.
But 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).

@@ Line 1: / Line 1: @@
 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.
+::* The default maximum size is 32 characters.
+::* But 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).