On Fri, Jan 10, 2020 at 4:30 PM Richard Hipp <d...@sqlite.org> wrote: > length() on a BLOB should show the number of bytes in the BLOB. > > length() on a string should show the number of *characters* (not > bytes) in the string up through but not including the first > zero-character. It is possible to have additional content after the > first zero-character in a string, which length() will not tell you about.
Hi Richard, There's no way at all, to know the length of a text column with embedded NULLs? --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users