"Greg and Tracy Hill" <tgh...@hotmail.com> wrote in message news:bay112-w186a5fad8703c04c8f30c0dd...@phx.gbl > Is it possible to use the BLOB literal sytax X'ABCD' with encoded > NULLs?
Yes. > For example: > > INSERT INTO mytable VALUES (X'BADF00D0') > > When I do this, the length of the data is 2 instead of the expected 4. How do you determine this? Not with strlen, I hope. select length(X'BADF00D0'); 4 Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users