SQLite Forum

HEX - What is the reverse function?
Common use cases for the hex() function include:

  *  Convert a binary blob into human-readable format.
  *  Generate a unique identifier or random password using
     an expression like:  "`hex(randomblob(20))`"
  *  Generate human-readable hash strings from extension functions
     like [sha3()](https://www.sqlite.org/src/file/ext/misc/shathree.c)
     that otherwise return a binary blob.  Ex: "`hex(sha3(...))`"
  *  To view the actual UTF8 (or UTF16) of a text string.