Update sqlite column type

Question

The columns in my table are currently "text", I need to change them to "text collate nocase". How would I go about doing this without losing data?

Answer 1

Just run an ALTER TABLE command on the column. You should not lose data, but test first.

Check out the docs for the exact syntax;

Answer 2

I recently had to do something similar. I used RazorSQL.

RazorSQL