SqlServerCe VarBinary Question

[Brett Miller]

Hi,

I need to fill a VarBinary Field in a table with +-19000 bytes (depends) The
Documentation says that the field can only be 8000 bytes long, and if I
change it to anything over that I get an exception.

There must be a way I can do this.

Help Appreciated,

Best Regards,
BM

 

[Jon Skeet [C# MVP]]

I need to fill a VarBinary Field in a table with +-19000 bytes (depends) The
Documentation says that the field can only be 8000 bytes long, and if I
change it to anything over that I get an exception.

There must be a way I can do this.

Well, the way to do it is to use the correct field type, which is Image
in this case.

 

[Val Mazur]

Hi,

What you need to do is to change datatype in your database to Image. Image
is exact same binary time, but it has different limitation on size -
2,147,483,647 bytes