Help with SQL (or other) code to change Column Type

Databases
1

Hello all,

I had used a column type of REAL in a SQLite database. Can anyone give me an idea how to change the Column Type from Real to CHAR?

Thanks all,
Tim

2

you want to jet copy the data to a temporary one, drop & recreate the table with whatever changed column definitions you need then copy the database

select * into tempTable from currentTable
drop table currentTable
create table currentTable (columns definitions in the same order but new types)
insert into currentTable select * from tempTable