SQLite strings with NUL

Question

1. Can strings in SQLite 3 include NUL characters?
2. If the answer to 1 is "yes", how can they be written in SQL queries? SQLite doesn't seem to have chr or char functions.

Answer 1

Not sure from which version onwards it is supported, but you can do it:

create table foo (bar data);
insert into foo(bar) values (x'001122334400ff');
select length(bar),hex(bar),bar from foo;