SQlite database contains " as char and how to retrive it as string : I have database of words which has " in the character.
I use Hotal.ttf fonts as my language doesnt have unicode support(yet).

Word in databse is: K"ME@ which looks like this: [![Oo ji matra][1]][1]

I am retrving this from android SQlite database and displaying it in text view.
here is the query code:

    String searchQuery = "SELECT kMean FROM dictionary WHERE eName LIKE '%" + search + "%' LIMIT 1";

However it is retrived as this: [![enter image description here][2]][2]

So i think it takes ' instead of " and hance letter [![enter image description here][3]][3] is displayed insted of [![enter image description here][4]][4]

Help please.


  [1]: https://i.stack.imgur.com/FXKeJ.jpg
  [2]: https://i.stack.imgur.com/TBjMd.jpg
  [3]: https://i.stack.imgur.com/Pb5i8.jpg
  [4]: https://i.stack.imgur.com/NNcyr.jpg