error, string or binary data would be truncated when trying to insert

From @gmmastros’s answer

Whenever you see the message….

string or binary data would be truncated

Think to yourself… The field is NOT big enough to hold my data.

Check the table structure for the customers table. I think you’ll find that the length of one or more fields is NOT big enough to hold the data you are trying to insert. For example, if the Phone field is a varchar(8) field, and you try to put 11 characters in to it, you will get this error.

Leave a Comment