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
