Search code examples
androidsqlitemax

Max length of Android Sqlite String?

In reference to this question:

How SQLite on Android handles long strings?

It says that default SQLite stores at 1 billion. This is the same as the actual site.

However, as the person states, it could be less. I was wondering if their is a way to check/what is this value?

Thanks!

Solution

  • The is no way to read SQLite limits in Android at runtime. (SQLite has a function for this in its C API, but Android does not expose this.)

    In any case, I do not know of any Android vendor that has reduced any of SQLite's limits. (Usually, they increase some limit or enable some option when they need it in their own apps or when they try to optimize, but they never bother to change something otherwise.)