Or of course you could query the sqlite_master table Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence
On 13 April 2016 at 18:08, Paul Sanderson <sandersonforensics at gmail.com> wrote: > you could use SQL i.e. > select typeof(col1) from table1 > > would return text, integer etc. for each row in the table for the > specified column. > > problems could arise if rows have NULL for given column or SQLite > slack of strict column affinity mena sthat someone has dropped a > string into an integer column. > > select typeof(col1) from table where col1 not null limit 1 > > mightbe a better option > Paul > www.sandersonforensics.com > skype: r3scue193 > twitter: @sandersonforens > Tel +44 (0)1326 572786 > http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit > -Forensic Toolkit for SQLite > email from a work address for a fully functional demo licence > > > On 13 April 2016 at 17:43, Simon Slavin <slavins at bigfraud.org> wrote: >> >> On 13 Apr 2016, at 10:57am, hfiandor <hfiandor at ceniai.inf.cu> wrote: >> >>> I have already obtained from a SQLQuery the field?s list. Now I need to >>> obtain the field?s type, from the SQLQuery obtained from a SQLite table. >> >> In the SQLite API you would use this >> >> <https://www.sqlite.org/c3ref/column_blob.html> >> >> int sqlite3_column_type(sqlite3_stmt*, int iCol); >> >> but you're not using the SQLite API. >> >> What programming language are you using. >> What API are you using to access SQLite ? >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users