Hi! If I define a column as BLOB type, will length() run strlen() on the data, or will it consult some kind of internal value to determine the length? The documentation says:
"For a string value X, the length(X) function returns the number of characters (not bytes) in X prior to the first NUL character. ... For a blob value X, length(X) returns the number of bytes in the blob." This suggests to me it uses some internal length value (eg, not strlen), but given that sqlite doesn't use strong typing, I'm wondering if I insert a string into that blob if it'll return the blob length or the string length. I ask because I'm going to be using sqlite on a performance-sensitive application to store small strings (as blobs), and one of the most frequent queries will be to get the length of the blob. I'm wondering if I should create a separate length column, or if I should just use length(). Thanks! -david
