String or binary data would be truncated - Add new row (Entity Framework)

Question

I get this error when I try to add a new row.

HexStringToByteArray("0x546F206A65737420707573747920706C696B0D0A");

String or binary data would be truncated.\r\nThe statement has been terminated.

attachement.ATF_ID = 244512;
attachement.ATF_WFDID = 160489;
attachement.ATF_ATTID = 244512;
attachement.ATF_Name = "teska14.txt";
attachement.ATF_FileType = ".txt";
attachement.ATF_Value = HexStringToByteArray("0x546F206A65737420707573747920706C696B0D0A");
attachement.ATF_FileIsOcr = 0;
attachement.ATF_CreatedBy = "test";
attachement.ATF_UpdatedBy = "test";
attachement.ATF_OrginalValueHash = HexStringToByteArray("0x4C35C01D7E10FB7F7440D39932265E7C7F09A4D17FEFB55AE9E1DDAC97AD373E");
attachement.ATF_OrginalName = "test.txt";
attachement.ATF_Version = -1;
context2.WFAttachmentFiles.AddObject(attachement);
//context.AddToWFAttachmentFiles(attachement);
//context.WFAttachmentFiles.AddObject(attachement);
context2.SaveChanges();

HEC Code:

public static byte[] HexStringToByteArray(string hexString)
{
    if (string.IsNullOrWhiteSpace(hexString))
        throw new ArgumentNullException("hexString");

    if (hexString.Length % 2 != 0)
        throw new Exception("Invalid hex string");

    var bytes = new byte[hexString.Length / 2];
    for (int i = 2; i < bytes.Length; i++)
    {
        bytes[i] = Convert.ToByte(hexString.Substring(i * 2, 2), 16);
    }
    return bytes;
}

It appears you changed your question, try checking db column size limits to resolve this error. — Ravi M Patel
– Ravi M Patel, Commented Mar 10, 2015 at 14:08
@RaviMPatel I copy this 0x546F206A65737420707573747920706C696B0D0A from ATF_Value from database. Now I want to send this for test to database. Using sql is very simple when I want to INSERT I write ATF_Value = '0x546F206A65737420707573747920706C696B0D0A' — Rafał Developer
– Rafał Developer, Commented Mar 10, 2015 at 14:28

MarkP · Accepted Answer · 2015-03-10 14:16:51Z

5

Usually when you see that error message:

String or binary data would be truncated. The statement has been terminated.

It means that one of the database columns is not big enough to hold the data you are trying to save.

In your case, check the size of the columns ATF_OrginalValueHash and ATF_Value in the database and maybe increase them

answered Mar 10, 2015 at 14:16

MarkP

5,0553 gold badges24 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Rafał Developer Over a year ago

I copy this 0x546F206A65737420707573747920706C696B0D0A from ATF_Value from database. Now I want to send this for test to database. Usig sql is very simple when I want to INSERT I write ATF_Value = '0x546F206A65737420707573747920706C696B0D0A'

MarkP Over a year ago

what is the datatype of the column in SQL Server - try setting it to VARBINARY

Rafał Developer Over a year ago

ATF_OrginalValueHash -> binary (32), ATF_Value -> image

MarkP Over a year ago

just noticed that that length of the data you are trying to insert to ATF_OrginalValueHash is 44 characters - which will cause the above truncation error. Try increasing the field size in the db

sshanzel Over a year ago

Damn! I've been working on this one for an hour already. Thank god i saw your post.

|

Ravi M Patel · Accepted Answer · 2015-03-10 14:17:08Z

4

Update

Basic idea is to make sure whether entity properties are translated to compatible sql columns or not.

One more solution is to use LINQPad, if you put your code there, it'll show you SQL statement fired by entity framework and that give you you sufficient insight to figure out why your code fails.

Usually this error shows up when you don't initialize the DateTime properties of your entity and you try to save changes to SQL Server database.

All c# DateTime properties are initialized to January 1, 0001, which is a minimum value of the type.

The minimum value of the datetime data type in Sql Server is January 1, 1753.

That results in out of range exception. If you initialize your DateTime properties accordingly, you shouldn't see this error. If appropriate in your scenario, you might as well consider using SqlDateTime.MinValue (reference) to initialize your properties.

edited Mar 10, 2015 at 14:17

answered Mar 10, 2015 at 14:04

Ravi M Patel

3,0952 gold badges27 silver badges33 bronze badges

1 Comment

Rafał Developer Over a year ago

I found solution for date but now I edited my post to this problem. "HexStringToByteArray"

Collectives™ on Stack Overflow

String or binary data would be truncated - Add new row (Entity Framework)

2 Answers 2

6 Comments

Update

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Update

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related