|
A hint for the future. If you want to have "productive" conversations dont start out by telling someone that has been using sqlite for 15 years highly successfully their API docs are wrong. And that too based on a cursory reading of documentation (which is exactly that, not a standard). Read section 3.1 of the documentation you linked to and you will be able to tell the type affinity of every column in the calibre database. Which is anyway entirely irrelevant since sqlite actually uses types per value not per column. You can store text in integer columns and integers in blob columns if you want.
|