none
varBinary(MAX) in MS SQL Compact Edition 3.5

    Question

  • Hello --

    I am trying to create a table with a variable length BLOB, one that can exceed the 8000 fixed length.  I found some notes about using MAX as the parameter, but when I create the database, I am getting an exception, noting that the MAX parameter is understood.

    So, the question is... are variable length blobs supported in MS SQL CE 3.5?  If so, what am I doing wrong??

    Thanks in advance for any help.
    Tuesday, March 03, 2009 11:51 PM

Answers

  • If you need to store blobs more than size of 8000 bytes then you need to use the "image" type for binary data and "ntext" for Unicode data.
    Wednesday, March 04, 2009 6:36 AM
    Moderator

All replies