On 10/25/05, Joe Wilson <[EMAIL PROTECTED]> wrote: > The built-in Sqlite length() function works just fine on blobs: > > sqlite> select length(X'0000000000'); > 5 > > Why do you think it doesn't?
I remember a few months ago noticing it would count UTF-8 chars, not bytes, so it would not return the right length for blobs in all cases (a '\0' is a valid UTF-8 char, but try with the '(c)' [copyright] sign, which is 2 bytes). I don't have the code in front of me, and can be just my memory, but I don't see that behaviour changing or would break a lot of SQL during normal text manipulation. Regards, ~Nuno Lucas
