No such thing, really. In SQLite the data types are associated with
the cell, not the column.
The "declared type" of a column that you've found is used to
establish preferences for how cells are stored, but it is not a hard
requirement (unlike most other SQL implementations).
-Eric
On 10 May 2006, at 16:25, sqlite wrote:
I want to know the type of a column, ie.:
INTEGER, TEXT, REAL or BLOB
There seems to be no function to do this.
I can get the "declared type" of a column but
that's not easy to decipher as SQL has a zillion
data types.
I tried "sqlite3_column_type()" but that function
only works when there's a valid row (and when there's
a valid row it fails when a column is empty!)
Is there any way to get the column type?