sqlite_field_type

mIRC SQLite

sqlite_field_type
Returns the type of the specified field.
Syntax
$sqlite_field_type ( result, field_index [, row_index ] )
Parameters
result
The result identifier.
field_index
The ordinal index of the field. The first field has an index of 1.
row_index
The row index to get the type for. Optional; If result is unbuffered or if omitted current row is assumed.
Return Value
The type of the field on success, or $null if there was an error.
Remarks
The returned type can be one of the following values: $SQLITE_INTEGER, $SQLITE_FLOAT, $SQLITE_TEXT, $SQLITE_BLOB and $SQLITE_NULL.

SQLite uses so called manifest typing, which means that field types aren't static.
This means that every row can store any type for any field. $sqlite_field_type can be used to determine the type of the field for a specified row.
There are exceptions to this, for details see Datatypes In SQLite Version 3.
See Also
sqlite_query