Why do I get "String or binary data would be truncated" as an error?

Question

I have a problem with this:

String or binary data would be truncated

And this is my coding:

String savePath = @"C:\Users\Shen\Desktop\LenzOCR\LenzOCR\WindowsFormsApplication1\ImageFile\" + fileName;

inputImageBox.Image = Image.FromFile(ImageLocation);
inputImageBox.Image.Save(savePath);

String sqlData = "INSERT INTO CharacterOCR(ImageName, ImagePath, Character, CharacterDescription)    
            VALUES('"+fileName+"', '"+savePath+"', '"+typeName+"', '"+CharDesc+"')";
SqlCommand cmd = new SqlCommand(sqlData, con);
cmd.ExecuteNonQuery(); // <<<<<error indicates here

What is the problem?

Answer 1

Look at the schema of your table and look at the max lengths. You're probably trying to insert something larger than the max length.

Answer 2

That just means that one of the values you're trying to cram into a column is too long for the data type you've defined for that column.

For example, trying to INSERT "Hello" to a column that's only a VARCHAR(4).