How I can make a variable to varbinary(max) when length limit is 8000 in SQL Server compact

Question

Yeah, stupid question but I cant make it to max even it should be possible. It just allows me to put only 8000 to varbinary and not max. I tried this in edit table schema when i right clicked the table in server explorer.

[SQL Server CE does not support varbinary(max), but you can use the "old" image type.](http://stackoverflow.com/questions/2638259/store-an-image-in-a-sql-server-ce-database) — , Jul 17 '13 at 15:04
Above comment should be turned into the answer and accepted. — cfeduke, Jul 17 '13 at 15:05

score 0 · Accepted Answer · answered Jul 17 '13 at 15:07

0

you cant! SQL server CE doesn't support VARBINARY(MAX) the equivilant would be image but i believe they are phasing that out

answered Jul 17 '13 at 15:07

Dev N00B

218
1
8

How I can make a variable to varbinary(max) when length limit is 8000 in SQL Server compact

1 Answers1