I am using sqlite3_column_type. I'l try sqlite3_column_dectype tomorrow. I'm hoping that the column type follows the intermediate result set from joins and views. It looks like I have to be sure SQLITE_ENABLE_COLUMN_METADATA is set.
Vance on Apr 09, 2013, Simon Slavin <slav...@bigfraud.org> wrote: > > >On 8 Apr 2013, at 4:16pm, ven...@intouchmi.com wrote: > >> I've done a query via a view. >> The column names that I retrieve are good. But, the column types are not. >> They >are always set to SQLITE_NULL (5) > >How are you trying to retrieve the column type ? What function call are you >using >? > >> whereas the values are either integers, or strings and no null values. >> Is there a way to obtain data type? > >SQLite does not have column types. Instead it has affinities. Each row of >each column >may have a value of a different type. So you can get the type of a particular >value, >but not the type of every value of a column. For more detail see here: > ><http://www.sqlite.org/datatype3.html> > >Simon. >_______________________________________________ >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
