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.
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.
That number can be reduced only if there are combinations of values are never selected.

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 2: / Line 2: @@
 :* 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.
+::* 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.
+::* That number can be reduced only if there are combinations of values are never selected.
 :* 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).