> Note that "defined as" (in the column declaration) means next to nothing in sqlite This is not true. I often had very strange problems when intuitively declaring a column as "STRING" instead of "TEXT". See e.g. [this thread](https://sqlite.org/forum/forumpost/3c9c49511c).