SqlServerCe VarBinary Question

  • Thread starter Thread starter Brett Miller
  • Start date Start date
B

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
 
Brett Miller said:
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.
Click to expand...

Well, the way to do it is to use the correct field type, which is Image
in this case.
 
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
 
Back
Top