I have just started with B4A and am struggling connecting to my SQLite 3.x database. I also notice that when I use SQLite Database Browser to try open any of the databases created by B4A (“1.db” from the DBUtils sample) it gives an error and says “File is not a SQLite 3 database.”
I am obviously missing something here, can you help?
I never used DBUtils (yet).
But did you try renaming the extension of the db file to .sql?
You can check the database records with:
Mozilla Firefox has a great plugin: SQLite Manager (do a Google search).
In this SQLite Manager you connect your database and will see immediately if the records are looking ok.
In the "db settings" tab there is a field: Encoding.
Standard this is set to UTF-8.