-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Divya K M wrote:
> I am using a GdkPixbuf and want to store the pixbuf created to the
> sqlite3 database.Please can you tell what's wrong in code found below.

It isn't using the SQLite API :-)  SQLite does fundamentally work with blobs
so the issue is the GDA layer you are using.

> GValue* bValue  =  gda_value_new_blob(str,len);
> dataValue = gda_value_new_from_string ( gda_blob_to_string
> (bValue,len), G_TYPE_STRING);

This is a horrendous way of using blobs with SQLite.  SQLite is a library in
the same process so there is no need to copy blobs around and encode them as
strings - it can work directly with them as bindings.

You are probably going to be better off asking on gnome lists and mention
you are trying to do blobs with SQLite.  In the doc I do see references to
GdaBlobOp which would provide the same interface as SQLite's incremental
blob i/o assuming gda has implemented that.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkpv4QQACgkQmOOfHg372QQs9ACePuJsBboYxlqlecldb0jGuDYC
2agAn1USBGQ6g3IURvr5N784UaqmT+D5
=bwwn
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to