Oops, forgot to use X before the storage (grrr!)
X'hexdata'
sqlite3_column_text returns a pointer to binary data wich i can copy by
obtaining the columndata size.
BLOB type is now properly returned as well :)
Thanks anyway.
----- Original Message -----
From: "Edwin Knoppert" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, July 29, 2005 4:21 PM
Subject: Re: [sqlite] BLOB field returns as TEXT type
Only the sqlite3_column_decltype() return "BLOB" but that might be any
declared keyword.
Point is that the lib knows that it must return the data in hex notation.
I would like to know how i can determine this as well so i can convert the
hex data back to normal.
----- Original Message -----
From: "Edwin Knoppert" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, July 29, 2005 3:39 PM
Subject: [sqlite] BLOB field returns as TEXT type
I'm expecting SQLITE_BLOB when using sqlite3_column_type()
It keeps returning SQLITE_TEXT (3) while the field was created as BLOB.
The text returned from sqlite3_column_text() is in hex notation.
At this time i don't mind the wrong type nr as long i can distinguish the
HEX blob data from ordinary fielddata (text e.o)
I have no problem with a conversion from hex to binary data, it's my wish
to use a common function to return any fielddata requested as binary
string data.
(And thus not knowing at forhand what datatype was stored)
How?
