I would like you to avoid what happened to me.
I was testing my app and data that my app extracted from the db did not correspond to those that were using the same query on SQLite Database Browser.
Immediately I thought of working on two different db, but I had taken the db directly from my smartphone, a moment before, so I discarded this hypothesis.
Then, the problem had to be in a routine of DBUtils. I followed step by step the few lines of the routine: the problem could not be there.
In short, in some strange way, if you "download" the db from your device, using Windows, you may find that you get an old version. In fact, immediately after, I used Eclipse to pick up the db and there was no problem!
I was testing my app and data that my app extracted from the db did not correspond to those that were using the same query on SQLite Database Browser.
Immediately I thought of working on two different db, but I had taken the db directly from my smartphone, a moment before, so I discarded this hypothesis.
Then, the problem had to be in a routine of DBUtils. I followed step by step the few lines of the routine: the problem could not be there.
In short, in some strange way, if you "download" the db from your device, using Windows, you may find that you get an old version. In fact, immediately after, I used Eclipse to pick up the db and there was no problem!