-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 03/01/2015 10:40 AM, David Barrett wrote: > 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?
sqlite> select cast(x'424446' as text); BDF sqlite> select length(cast(x'4244460048' as text)); 3 sqlite> select length(cast(x'4244460048' as blob)); 5 Length of blob is number of bytes. Length of text is number of characters until first null byte. I'll leave it up to you to figure out what happens with multibyte characters. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlTzeyYACgkQmOOfHg372QSp5QCdEwDFmFfCcwEgR0J7D5uUzlAq J1gAniGY88fNty/pv7qq2zUZ5RWxZKZs =qUxe -----END PGP SIGNATURE-----
