Product Solutions Support
Try MemSQL

SHA2

Hashes the given string or binary data using the secure hash algorithm, version 2. As of this writing (early 2015), SHA2 is considered secure for generating collision-resistant hashes.

SHA2 ( plaintext, bitlen )

Arguments

Return Type

Lower case hexadecimal digits corresponding to the binary hash value.

Examples

memsql> select sha2('ohai', 0);
+------------------------------------------------------------------+
| sha2('ohai', 0)                                                  |
+------------------------------------------------------------------+
| e84712238709398f6d349dc2250b0efca4b72d8c2bfb7b74339d30ba94056b14 |
+------------------------------------------------------------------+

memsql> select sha2('ohai', 256);
+------------------------------------------------------------------+
| sha2('ohai', 256)                                                |
+------------------------------------------------------------------+
| e84712238709398f6d349dc2250b0efca4b72d8c2bfb7b74339d30ba94056b14 |
+------------------------------------------------------------------+

memsql> select sha2('ohai', 384);
+--------------------------------------------------------------------------------------------------+
| sha2('ohai', 384)                                                                                |
+--------------------------------------------------------------------------------------------------+
| 2e2f6fcb70ea17cb674d7ba268026e30bde4cbe7abd74adc80d47f56ab15a5cc3e4e11e661cc22075a5b3b111bcc9afb |
+--------------------------------------------------------------------------------------------------+

memsql> select sha2('ohai', 512);
+----------------------------------------------------------------------------------------------------------------------------------+
| sha2('ohai', 512)                                                                                                                |
+----------------------------------------------------------------------------------------------------------------------------------+
| c8bd85242ad59306e2f5cd0f26c44408bf4e9a7c6b6f3f8317fd226bd131435400eff8de7b5f9927ea4aa4c0624cdd3a23630b1b5ab76207adae442e019284e5 |
+----------------------------------------------------------------------------------------------------------------------------------+
Was this article useful?