I have a table : Table foo( col1 integer primary key, *col2 int*, col3 text )
And I want to be able to change this to : Table foo( col1 integer primary key, *col2 text*, col3 text )I want to do this, because I have an "enum" in col2 and want to be able to use custom collate function and sqlite3 doesn't allow me to use custom collation with integers, which makes sense.
I can think of dropping and adding the table back again, any other better ideas out there ?
TIA, Sandeep.