SQLite Forum

HEX function returns empty string on null input, normal?
Login
Based on the documentation I am tempted to say yes.

https://sqlite.org/lang_corefunc.html#hex

"The hex() function interprets its argument as a BLOB and returns a string which is the upper-case hexadecimal rendering of the content of that blob."