SQLite does not support altering a column type directly. Learn the safe table rebuild procedure to migrate column types, preserve data, restore indexes and triggers, and avoid silent data loss from foreign key cascades.
Continue reading
SQLite Change Column Type Without Losing Data: The Safe Rebuild Guide
on SitePoint.
