On 10/31/05, Joe Wilson <[EMAIL PROTECTED]> wrote: > [...] But if > for some reason you absolutely must need to know the number of bytes > that a text or blob value takes from within the Sqlite SQL language, > just refer to the documentation of typeof(), CAST, CASE and quote() > and you can come up with a pure Sqlite SQL solution if you really > wanted to.
Good tip! Didn't remember that as CAST is relatively recent - v3.2.3 - and it's not in my system, yet. Anyway that seems to take care of a generic way to obtain the byte count of a field, so no need for a builtin function. Now the only thing left is a way to get part of blob without having to read the entire row into memory, but that probably would not be easy... Regards, ~Nuno Lucas