SHA2

​

Syntax

​

Scalar

sha2(value, bit_length)

​

Arguments

​

Returns

• Type: STRING
• Possible values: A lowercase hexadecimal digest of 56, 64, 96 or 128 characters for 224, 256, 384 or 512 bits.
• NULL behavior: Returns NULL when either argument is NULL or bit_length is unsupported.

​

Properties

​

Usage notes

• The bit length may vary by row; it is not required to be a constant expression.

​

Examples

​

Value and NULL input

SELECT sha2('abc', 256) AS digest, sha2('abc', 0) AS zero_selects_256, sha2('abc', 123) AS invalid_size;

​

Choose a digest size

SELECT sha2('abc', 224) AS digest_224;