String or Binary Data

Last updated
Save as PDF

Have you seen this error or different variations of String or Binary data would be truncated?

This means the field the form is saving to in SQL, is too small for the data that was entered on the
form. There are two ways you can resolve this. You can verify the column size in SQL is the
same as the FieldSize on the form. However, if your form isn’t setup correctly, you can run the
risk of having the error reoccur even after this change. Within the object inspector, there is a field
named MaxLength. What this does is stop the user from entering in data larger than the allotted
size for the column. If you don’t have this filled out, even though you have the FieldSize set to
100, TIER® will still allow you to enter past that allotted size. Depending on how big your column
size is, to be on the safe side, make sure your MaxLength is the same as your FieldSize length.