"String or binary data would be truncated. The statement has been terminated" Error on survey123 iOS only.

SamLee__MES_

A survey I published in survey123 is recieving the following error "String or binary data would be truncated. The statement has been terminated". This error only occurs on iOS devices. Is this a know issue where the iOS version of survey123 adds additional characters to multi-answer questions.

Anonymous User

Hi Sam,

This error means that there is data in one of the fields in the survey that has more characters than the fieldLength set for that field. So when you try and submit that record it will truncate the data in that field. Can you share your xlsx file so we can take a closer look?

Regards,

Phil.