Hello Buddies,
I have inserted into database using the sqlite api function "int
sqlite3_bind_blob(sqlite3_stmt*, int, const void*, int n,
void(*)(void*));".Here before binding I have converted the const void * to
CString.
I am trying to retrieve the data using the sqlite api function "const void
*sqlite3_column_blob(sqlite3_stmt*, int iCol);"
Regards,
G.Satish.
-----Original Message-----
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jens Miltner
Sent: Thursday, April 02, 2009 3:12 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Converting BLOB Data type to String
Am 02.04.2009 um 07:45 schrieb SATISH:
> Hello Buddies,
>
> I have written a string into database by converting into
> "BLOB Data
> Type".writing into database is Ok I got a problem when reading from
> the
> database to read a blob from the database I am using the function
> "const
> void *sqlite3_column_blob(sqlite3_stmt*, int iCol);" this functions
> returns
> me const void * where I want to convert this into "CString".please
> any one
> of you can help me in converting const void * to CString.
How did you write the data to the database? SQLite does not have per-
column data types, but rather uses per-value data types, i.e. whatever
your inserted the data as will be used as the data type for that value.
Did you try to just retrieve the value as a string (using
sqlite3_column_text)?
</jum>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
