SQLite Forum

HEX function returns empty string on null input, normal?
Login
There was once a gentleman strolling through the Jewisch district who came upon a shop where the sole item one display in the window was a golden pocket watch. This piqued his interest, so he entered to inquire about the price, but was told the watch was not for sale and that he was at the community mohel's office, whose duty is to perform circumcisions.

"Is it not a little misleading to advertise this by displaying a pocket watch?", he inquired.

"Tell me, what should I display instead?"

So what should a string valued function like hex() return instead?