System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated.

Question

Hi Am working on Events Admin page in that am getting this error for some of the events posting whats this error means and how to resolve please help to me.  System.Data.Sql Client.SqlExcep tion: String or binary data would be truncated. The statement has been terminated . Thank You

Sukesh Marla · Answer

This kind of error occur when you try to insert values into the column of size greater than its max length. Check this is correct answer if it helped

Vulpes · Answer

It sounds like you're trying to insert data into a column whose length exceeds the maximum length for the column. For example you're trying to insert more than 8000 bytes into a column of type varchar. So I'd check to see if that's the case and if it is try and abbreviate the data to fit into the column.