Re: [sqlite] BLOB field returns as TEXT type
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: 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: 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?
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: 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?
[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?
