Using an existing VARCHAR column with room

I am trying to use my existing db with Android Room. However, one of my tables has a VARCHAR column.

It seems the room only supports TEXT, not VARCHAR. And sqlite does not allow changing the column type.

So, is there a way to use an existing table with VARCHAR fields in the Room? Or do I need to copy the entire table to a new one, replacing VARCHAR with TEXT?

+6
source share

All Articles