Skip to content

String or binary data would be truncated (SQL Version Only) ​

SQL cannot truncate values when storing them into records in the SQL database. If a user tries to enter a value that is longer than the field length, they will get the above error.

To avoid the error, fields on all templates that submit data to the SQL tables must have a maxlength set to the maximum length of the field.

This applies to the following templates: Attachments.awp, Attendtrack.awp, ChangePwd.htm, CourseProposal.awp, Credentials.awp, CustomRegister.htm, Gradebook.awp, Person.awp, Proxyreg.awp, Xperson.awp.

This also applies to any custom express registration and data capture templates you are using.

Also remember, if you are adding fields to any ACEweb templates, you will need to ensure they have the correct maxlength value set. You can find field lengths in the Data Structures help topic.