On 1 Mar 2015, at 6:40pm, David Barrett <dbarrett at expensify.com> wrote:
> I'm wondering if I insert > a string into that blob if it'll return the blob length or the string > length. You can put a value of any type into a column of any affinity. i.e. you can put a BLOB into a BLOB column or a string into a BLOB column. What the length() function does depends on what type the value has, not what type the column has. > I ask because I'm going to be using sqlite on a performance-sensitive > application to store small strings (as blobs) Why aren't you storing strings in string columns ? Internally to SQLite, string values and BLOB values are handled almost identically. Simon.
