I have some data in table,(say _id,name), name is encrypted where as id is auto generated value.
I want to show the data in a ListView and I'm using SimpleCursorAdapter for keyvalue mapping.
But I am getting an error saying
android.database.sqlite.SQLiteException: unknown error: Unable to convert BLOB to string
This is because the encrypted data is stored in byte.
My question is,
how can I convert the name column into original string and show in ListView?
I have a method for decryption.
Actually I want a functionality as, when user clicks on Name in the list, I should get corresponding id and I found SimpleCursorAdapter doing same thing as given in Notepad sample.
I am able to do my work as expected following the article but I am not getting each name on each row of list, I am getting same name (first from db) on each row, however, when I check the id in onListItemClick() method I am getting correct id for each name.