Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php

 The value returned by sqlite3_column_type() is only meaningful if no 
type conversions have occurred as described below. After a type 
conversion, the value returned by sqlite3_column_type() is undefined.

What do you mean by "no type conversions have occured", "as described below" > am I missing something? Where in my code am I making any type conversions?

I don't quite understand, what is this function for, if it always returns SQLITE3_NULL ?

I was creating a web based browser for sqlite3 database files, in column headers I want to display column type:

Id (int) | Name (varchar)

That's all, what is the way of doing that?

I've found a solution, but it looks like a way around, using columnType() would be easier. I am parsing the "CREATE TABLE..." sql that i fetch by querying sqlite_master table, using a simple regexp. Here is the function:

function sqlite3_columns($table)
{
	global $db;
	// $result->columnType(0) - bug, always returns SQLITE3_NULL
	$query = sprintf("SELECT * FROM sqlite_master WHERE type='table' and name='%s'", $table);
	$result = $db->query($query);
	$row = $result->fetchArray(SQLITE3_ASSOC);
	$result->finalize();
	$sql = $row['sql'];
	preg_match_all('#[\(,]\s*(\w+)\s+(\w+)#', $sql, $pmatch);
	$columns = array();
	foreach ($pmatch[1] as $k => $colname) {
		$columns[] = array('name'=>$colname, 'type'=>$pmatch[2][$k]);
	}
	return $columns;
}

I believe you need to fetch a result for columnType to work since it can be different for each row.

Perhaps querying sqlite_master would be easiest?