SQL Server String or binary data would be truncated

When you save whole image data then datatype will be Image But only save image path then use varchar(max) and NVarchar(max) as per your requirement

+1

Anupam Maiti5y ago

This error happens when your target column size does not accommodate with value that you trying to insert.

Please try with varchar(max) or nvarchar(max)

+1

Surya K5y ago

You can use NVARCHAR(MAXIMUM_LENGTH).

Since NVARCHAR uses 2 bytes per character, that's approx. 1 billion characters can be stored.

The max size for a column of type NVARCHAR(MAXIMUM_LENGTH) is 2GB of storage.

+2

Sachin Singh5y ago

Varchar of what?

Make it max.

Varchar(MAX)

+2

Rajanikant Hawaldar5y ago

increase varchar size of column in which your tryig to store imagepath

+1