About Androdi in SQLite 3 using GBK encoding storage, database Chinese garbled problem.

1, recently developed a project, with SQLite Expert personal Open the database, such as title will produce garbled, problems.

2, because SQL Lite is the default storage UTF-8 format, later change the database encoding type is ANSI, according to the operating system, the local ANSI for the GB2312 format, view found encoding format is normal.

3, using the Android program read, in the following way, you can read the full text characters.

Product pr=new Product();
            / / Solve the problem of Chinese garbled
            Byte[] val = cursor.getBlob(cursor.getColumnIndex("title"));
            pro.setTitle(new String(val,"GBK"));//Set the encoding method 

About Androdi in SQLite 3 using GBK encoding storage, database Chinese garbled problem.