Data Limitations

The following table describes Workbench limits on data items.

Item Limit
Longest string allowed for calculations 16,383 characters
Max longvarchar/blob length 10 MB (unless lower due to other database/driver limits)
Earliest date January 1, 1900
Latest date December 31, 9999
Max numeric precision 15 digits
Largest positive number 9.99999999999999E307
Smallest negative number -9.99999999999999E307
Smallest positive number 1E-307
Largest negative number -1E-307
Max formula length 1,024
Maximum number of nested levels of functions 7
Max source fields 65,536
Max target steps 65,536
Max target fields (data links) 65,536