androidsqliteandroid-studioutf-8db-browser-sqlite

Database file loaded in the wrong encoding: 'UTF-8'


I know there are two similar questions asked about this issue, but both questions did not receive any explicit solutions. I have also tried the solutions mentioned but none solved mine.

My issue is that I have a database created (using DB Browser for SQLite). When I pasted the db in the assets > databases folder, the error appeared. See attached picture for reference.

DB ERROR:

DB ERROR

Solutions I've tried:

  1. click the 'reload in another coding' option and still select on UTF-8 as stated on one of the solutions mentioned here (File was loaded in the wrong encoding:'UTF-8' in IntelliJ IDEA).

  2. Set UTF-8 for all encoding - IDE, Project & Default, as stated here (Android Studio Project Encoding Error).

None of the above-mentioned solutions worked for mine.

As such, I'd like to know if there are other alternative solutions I can use to solve this problem? Or should I just reload to another type of encoding? (but most of the options showed the red/grey exclamation mark too.)


Solution

  • I solved this problem by doing NOTHING.

    If anyone else experience this problem, you may just continue on with your development and ignore the not-so error. It will not affect your development in the future.