> Information like
> 1. Charset - character set used in the database
> 2. Collation - Collation method used in the database
> 3. Encryption - Encryption method used in the database
> 4. Casesensitve - Case sensitive details
> Can I get all of these details ablout the database?
There’s no way to find out encryption. Many installations of SQLite don’t support it at all. When it is supported it might be by several different encryption systems, and there’s no standard way to figure out which one it is. The makers of SQLite developed one of the encryption methods, but I have no idea whether that’s frequently used in comparison with others.
Collation and case sensitivity (called NOCASE in SQLite) are set for each column, though they can be overridden in places which refer to those columns, e.g. indexes and comparisons. You can find out some things