Yes but none of those functions return the class that the declared type maps to (SQLITE_TEXT, SQLITE_FLOAT etc), they just return the SQL type as a string, of which there are umpteen possibilities.
Presumably then Im going to have to map them to the class myself? My question was, is this the case, or is there some other function in the API that will do this for me that Ive overlooked? My reason for doing this is, if a field is null, I still need to know what class it 'should' have been if it had been storing a value. On 31/08/10 02:58, Roger Binns wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 08/31/2010 06:33 AM, Andrew Wood wrote: > >> I need to detect the declared storage class of a field rather than the >> actual type stored, but as I understand it sqlite3_column_decltype >> returns the SQL type not the SQLite storage class? Is there a way to get >> this info? >> > http://www.sqlite.org/c3ref/column_blob.html > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAkx8Yb0ACgkQmOOfHg372QTp4wCeKIQzs1RD0E51ZT94bUoMMRWA > rqcAnjID6Fklsj1cPBQwCVHjXQxLZuu+ > =Bscw > -----END PGP SIGNATURE----- > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ______________________________________________________________________ > This email has been scanned by the MessageLabs Email Security System. > For more information please visit http://www.messagelabs.com/email > ______________________________________________________________________ > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
