[sqlite] sqlite3_column_type() returns SQLITE_NULL even though it contains text

[Stadin, Benjamin]

Hi,

I was missing a few records in my program. After debugging further, I found 
that sqlite3_column_type () returns SQLITE_NULL for some objects (like 10 in 
2000), even though these actually contain text data. 

Is this normal? And how should I handle it properly (I mean, check if it’s 
proper 0 escaped text for example)?

Below is an example object returned by sqlite3_column_value() which is reported 
as SQLITE_NULL.

I’m using the latest SQLite 3.20.1.

Thanks
Ben

val     sqlite3_value * 0x10201a618     0x000000010201a618
            u   MemValue
            flags       u16     1
            enc u8      '\x01'
            eSubtype    u8      '\0'
            n   int     6
            z   char *  "BB.999"        0x000000010201e340
            zMalloc     char *  "BB.999"        0x000000010201e340
            szMalloc    int     1200
            uTemp       u32     0
            db  sqlite3 *       0x100406f10     0x0000000100406f10
            xDel        void (*)(void *)        NULL    0x0000000000000000

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users