encoding character in sqlite android
<p>Hello i am reading english and afrikaans language from two different file and put into one sqlite database the word is correct in afrikaans language for example </p>

<p>the afrikaans word is below</p>

<pre><code>    'n slegte lot
     'n voël die wilde diere van die prooi
      'n trekvogel
</code></pre>

<p>==========================================================</p>

<pre><code>        public class MainActivity extends Activity {

DbAdapterSDCard db;

@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    String array[] = { "afrikaans" };
    for (int j = 0; j &lt; array.length; j++) {
        String filePath1 = "/sdcard/Dictionarys/english.txt";
        String filePath2 = "/sdcard/Dictionarys/" + array[j] + ".txt";
        String UTF8 = "utf8";
        int BUFFER_SIZE = 8192;
        int i = 0;
        System.out.println(array[j]);
        db = new DbAdapterSDCard(array[j]);
        try {
            db.open();
            File file = new File(filePath3);
            file.createNewFile();

            BufferedReader br1 = new BufferedReader(new InputStreamReader(
                    new FileInputStream(filePath1),UTF8), BUFFER_SIZE);

            BufferedReader br2 = new BufferedReader(new InputStreamReader(
                    new FileInputStream(filePath2), UTF8), BUFFER_SIZE);

            String sCurrentLine1, sCurrentLine2;

            while ((sCurrentLine1 = br1.readLine()) != null
                    &amp;&amp; ((sCurrentLine2 = br2.readLine()) != null)) {
                db.insertTitle(sCurrentLine1, sCurrentLine2);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        try {

            db.close();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
</code></pre>

<h1>    }</h1>

<p>but in sqlite it is inserted like this way
<img src="http://i.stack.imgur.com/4VQMv.png" alt="enter image description here"></p>

<p>both have encoding UTF-8 Character set...........</p>

<p>can anybody suggest me i have tried so much but could not be success</p>

<p>encoding in txt file is below</p>

<p><img src="http://i.stack.imgur.com/JJuB3.png" alt="enter image description here"></p>

<p>now if i use encoding utf-8 the character will not shown proper :(</p>

<p><img src="http://i.stack.imgur.com/XqMgm.png" alt="enter image description here"></p>
