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
