Hash Functions

MD5(string)

Returns the MD5 hash as a string that contains 32 hexadecimal digits.

Returns NULL if string is NULL.

SHA1(string)

Returns the SHA-1 hash as a string that contains 40 hexadecimal digits.

Returns NULL if string is NULL.

SHA224(string)

Returns the SHA-224 hash as a string that contains 56 hexadecimal digits.

Returns NULL if string is NULL.

SHA256(string)

Returns the SHA-256 hash as a string that contains 64 hexadecimal digits.

Returns NULL if string is NULL.

SHA384(string)

Returns the SHA-384 hash as a string that contains 96 hexadecimal digits.

Returns NULL if string is NULL.

SHA512(string)

Returns the SHA-512 hash as a string that contains 128 hexadecimal digits.

Returns NULL if string is NULL.

SHA2(string, hashLength)

Returns the hash using the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, or SHA-512).

The first argument string is the string to be hashed and the second argument hashLength is the bit length of the result (224, 256, 384, or 512).

Returns NULL if string or hashLength is NULL.