> 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.
Why do you need that? No matter what you declare field can store any type of data. And in SQLite there's no "declared storage class". You are talking either about "affinity", or "declared column type", or "actual data type stored'. So which one of those 3 exactly you want to know and why? Pavel On Thu, Sep 2, 2010 at 9:22 AM, Andrew Wood <ajw...@theiet.org> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users