On 10 Jan 2020, at 18:03, Richard Hipp <d...@sqlite.org> wrote: > On 1/10/20, Dominique Devienne <ddevie...@gmail.com> wrote: >> >> There's no way at all, to know the length of a text column with embedded >> NULLs? >> > > You can find the true length of a string in bytes from C-code using > the sqlite3_column_bytes() interface. But I cannot, off-hand, think > of a way to do that from SQL.
But if I store UTF-8 in a TEXT column, surely I'm allowed to include NULLs in that? They are after all valid UTF-8 characters. -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users