SQLite Forum

HEX function returns empty string on null input, normal?
Login
NULL, however, can never be interpreted as some value, blob or otherwise.  NULL is the absence of any value, not a zero-length content of some type.