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
>

Reply via email to