Error: String or binary data would be truncated in the table

Issue Description

This issue most commonly pops up while performing,

• Stored procedure Execution

• Linq query

• Query Mapping a Column field to a Column field with a restricted size

• Performing Edit to SQL table with column restricted with size etc.

Common errors are as below,

OR

This error is also visible on SQL Server management studio if executing the commands,

Resolution

The issue can be solved by identifying the target Column Name and its limitation of size. Once identified you should increase the size of the column accordingly.

For Example :

If your Database has a column ‘FirstName‘ as varchar(10) and if you trying to save content/data either through mapping or regular set is by any means greater than > 10, then this error is possible.

How to identify the Column name with the Size issue?

If an error occurs while storing Stored procedure Execution or Query Mapping a Column field to a target Column field with a restricted size, such a coding issue can be resolved by implementing a proper exception handling mechanism to identify the properties with restricted size.

Example:

     catch (SqlException sqlException) 
        {
                throw;
        }

Please note that the changes you made will not be committed to the database due to this error.

I have seen some tend to use varchar (MAX) which I believe is not a good idea considering the performance issues associated with it.

So be specific on the size limitation if possible and use your experience to refine the size of the column.

For anything on the database side besides the above solution, you will have to alter or drop the table and create a table with the updated schema to fix the issue.

References:

• Getting Started with Entity Framework – ORM in ASP.NET Core

That’s all! Happy coding!

Does this help you fix your issue?

Do you have any better solutions or suggestions? Please sound off your comments below.

---

Please bookmark this page and share it with your friends. Please Subscribe to the blog to receive notifications on freshly published(2024) best practices and guidelines for software design and development.

---