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?
source
share