SQLite Forum

Setting non-binary columns to null in a table with a binary column populated with data creates free space and a larger file
Login
The schema in the above reads

```
CREATE TABLE [Data1](
  [Data] BLOB, 
  [Items_id] INTEGER, 
  [Key] TEXT);
```