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