This seems to be the result of creating a table as:
CREATE TABLE temp AS SELECT * FROM another_table
Surely the datatypes of the original query (SELECT * FROM another_table) should be used for the new table temp?
See http://www.sqlite.org/cvstrac/tktview?tn=521.
The problem is fixed in version 3.0.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
