Forum Topic

While insert data through insert query I got this error anyone have solution for this error?

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 table where you try to insert it. 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 into it, you will get this error.

Thank You so much. It works for me. I am increasing the size of my field and my insert query is executed successfully.