Android Question Sqlite passworded by default

[Endien]

I had create an sqlite database with android on external memory card. I use default sql library, not sqlcipher

And when i tried to access the database using sqlite desktop, its said the database might be encrypted and its asking the password.

As far as i know, sqlite is not passworded by default.

Any comment guys?

 

[ArminKH]

you should post the relevant code or an small sample to reproduce your problem

 

[Endien]

you should post the relevant code or an small sample to reproduce your problem

Thank you for the repy arminkh.

The code just fine. The code i use just like the tutorial by Erel. https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content

And in the code there were no set password method or such (i dont know how to set sqlite password programmatically).

I tried to access the table using sqlite desktop software to create indexes on the table because i feel the table loading operation kind of slow. (I use dateTime field as parameter into a query and this dateTime field was not indexed)

But when i tried to open the database with sqlite desktop software, its asking for password.

While the database can not be open, i just use b4a code to set the index within the Activity_Create event.

So i ask this forum, is it android put sqlite database password by default? (as far as i know, it doesn't).

 

[Erel]

No password is added. Maybe your desktop app doesn't support the SQLite version.

 

[Endien]

No password is added. Maybe your desktop app doesn't support the SQLite version.

Thanks for the reply, Erel.

When i tried to open the database file using another sqlite desktop software, it show message "The database disk image is malformed".
After a few search, the info i get is this message shown on corrupted database file.
But since i can still do sql operation with the database on android, i'm not sure that it got corrupted.
So i tried to copy the database file from android phone once again, and there it is, i can open it.

I don't know, maybe something wrong previously while i attempt to copy the database file.
Anyway, thanks for the reply guys.