Cryptographic Hash Functions

These standard hash functions accept a TEXT or BLOB input and return a hash as a BLOB. These functions are provided by the sqlean "crypto" extension which is built into SQL Notebook.

Syntax

MD5(data)
SHA1(data)
SHA256(data)
SHA384(data)
SHA512(data)


Return Value

The calculated hash as a BLOB.

Example

PRINT HEX(MD5('abc'));
-- prints "900150983CD24FB0D6963F7D28E17F72"