Update sqlite column type

The co开发者_StackOverflow社区lumns 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?

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;

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

RazorSQL