On 21 Sep 2017, at 3:21am, K, Rajasekar <k.rajase...@siemens.com> wrote:
> 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? Charset is database-wide: <https://sqlite.org/pragma.html#pragma_encoding> 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. <https://www.hwaci.com/sw/sqlite/see.html> 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 <https://sqlite.org/pragma.html#pragma_collation_list> <https://sqlite.org/pragma.html#pragma_table_info> <https://sqlite.org/pragma.html#pragma_index_xinfo> but neither collation nor case sensitivity apply to the database as a whole. Your question suggests that you are not familiar with SQLite, and that you’re interested in information about databases created by other people, not by yourself. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
