SQLite supports several datatypes: NULL for empty, INTEGER and REAL for signed integers and floating point values respectively, TEXT for text strings, and BLOB for binary files.

Testing with a database file with a 1.9 GB table and a 800 MB index (yikes!) dropping the index frees up that 800 MB after running sqlite_sparse, but an immediate "get info" doesn't show this.