select query gives strange characters as output

67 Views Asked by At

I have a problem when executing select query in android with sqlite database. In database there is a field based on sinhala characters. I populate the database using DB browser in UTF-8 encoding. I used SQLiteAssetHelper to access database in assets folder. when i try to use select query and display in android textview the data in field based on sinhala outputs strange characters like විද්â€.

I try to change the font in textview and try to change the encoding by using System.setProperty( sinhala_word,"UTF-8" ). As example when try to set word

රහිත

in android text view it shows like

රහිත

this is how my database looks like: this is how my database looks like

This is how text appears in text view: This is how text appears in text view

0

There are 0 best solutions below