1. Charset - character set used in the database http://www.sqlite.org/pragma.html#pragma_encoding Though as someone mentioned this is just the internal representation, and not necessarily what you'll get back from your language of choice.
2. Collation - Collation method used in the database http://www.sqlite.org/datatype3.html#collating_sequences Collation is defined on a per-field level and there are 3 built-in ones. The only place this info is stored is in the sql text in sqlite_master and needs to be parsed out to examine it. http://www.sqlite.org/pragma.html#pragma_collation_list can tell you if there's anything more than the standard 3 defined. 3. Encryption - Encryption method used in the database Part of the security is not telling you :p 4. Casesensitve - Case sensitive details http://www.sqlite.org/datatype3.html#collating_sequences NOCASE is one of the collating sequences, the rules for which collating sequence wins in any particular comparison are in there. http://www.sqlite.org/pragma.html#pragma_case_sensitive_like This doesn't actually have a form that gives you the current setting, which kind of sucks, but does let you set it yourself. Know that in SQLite there are a lot of things which are left to the accessing connection and whatever it was compiled with or set up with. Even enforcing foreign key constraints is a connection-level thing which defaults to off for example. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users