I am using C++/VC++ language as a wrapper for accessing SQLite. I have tried using memcpy as well but of no use. On Mar 9, 2015 11:07 PM, "Richard Hipp" <drh at sqlite.org> wrote:
> On 3/9/15, reddy ykk <ykk157 at gmail.com> wrote: > > Hi Sir, > > > > I have a requirement of reading an image data (BLOB) from a database. > > I could successfully read the length of the blob using > > sqlite3_column_bytes() but when i try to read the entire blob using > > sqlite3_column_blob(), i am getting undesired results. > > > > I am getting the bytes till NULL terminated string is present. In my > case, > > only 3 bytes of data are being returned by the method. > > Is there any way that if we specify the length, the whole blob data is > > retrieved irrespective of the NULL bytes . > > > > SQLite always returns the full BLOB if you give it the right length. > zero bytes do not make a difference. > > If you BLOB is getting truncated, perhaps that is due to whatever > wrapper interface you are using to access SQLite. What programming > language are you using? > > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >