In android show text of latin1_swidish_ci field in original decoded form

Question

I am reading text from DB and its collation type for text is latin1_swidish_ci and it is having some characters like this streets — the new normal? and its actual form is "streets - the new normal?" . How can is i decode this text to show the actual text?

Answer 1

— is hex E2 80 94 in latin1
— (em dash) is hex E28094 in utf8

You have "Mojibake". See this for discussion of what causes it and how to deal with it.