"Greg and Tracy Hill" <[email protected]> wrote in message news:[email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
