Binary Functions¶
- hash(x) integer ¶
Computes the hash of x.
- md5(x) varbinary ¶
Computes the md5 of x.
- sha1(x) varchar ¶
Computes SHA-1 digest of x and convert the result to a hex string. Note: x can only be varbinary type.
- sha2(x, bitLength) varchar ¶
Calculate SHA-2 family of functions (SHA-224, SHA-256, SHA-384, and SHA-512) and convert the result to a hex string. The second argument indicates the desired bit length of the result, which must have a value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If asking for an unsupported bitLength, the return value is NULL. Note: x can only be varbinary type.
- xxhash64(x) integer ¶
Computes the xxhash64 of x.