How do I store images on the SQL Server CE database?
A12: SQL Server CE supports the image data type. However, most Windows CE devices have limited memory. Therefore, you must be careful not to use all your available storage space. If you program to the OLE DB layer, you can use either the ILockBytes interface or the IsequentialStream interface to move binary large object data in and out of the database. Microsoft ActiveX Data Objects for Windows CE (ADOCE) also supports binary large objects. View the GetChunk method and the AppendChunk method on the recordset objects in ADOCE. With the GetChunk method and the AppendChunk method, you can read from and write to a large object column in the database. You can use an array of bytes inside the variant through ADOCE C++. You must make sure that you use an updateable cursor in SQL Server CE to store binary large objects. In other words, use a base table cursor so that the AddNew function call works correctly.
