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 |