Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
SHA2
On this page
Hashes the given string or binary data using the secure hash algorithm, version 2.
Syntax
SHA2 ( plaintext, bitlen )
Arguments
-
plaintext: the data to hash.
-
bitlen: the size of the hash to create.
Currently SingleStore supports only the values 256, 384, 512, and 0 (equivalent to 256).
Return Type
Lower case hexadecimal digits corresponding to the binary hash value.
Examples
SELECT SHA2('ohai', 0);
+------------------------------------------------------------------+
| SHA2('ohai', 0) |
+------------------------------------------------------------------+
| e84712238709398f6d349dc2250b0efca4b72d8c2bfb7b74339d30ba94056b14 |
+------------------------------------------------------------------+SELECT SHA2('ohai', 256);
+------------------------------------------------------------------+
| SHA2('ohai', 256) |
+------------------------------------------------------------------+
| e84712238709398f6d349dc2250b0efca4b72d8c2bfb7b74339d30ba94056b14 |
+------------------------------------------------------------------+SELECT SHA2('ohai', 384);
+--------------------------------------------------------------------------------------------------+
| SHA2('ohai', 384) |
+--------------------------------------------------------------------------------------------------+
| 2e2f6fcb70ea17cb674d7ba268026e30bde4cbe7abd74adc80d47f56ab15a5cc3e4e11e661cc22075a5b3b111bcc9afb |
+--------------------------------------------------------------------------------------------------+SELECT SHA2('ohai', 512);
+----------------------------------------------------------------------------------------------------------------------------------+
| SHA2('ohai', 512) |
+----------------------------------------------------------------------------------------------------------------------------------+
| c8bd85242ad59306e2f5cd0f26c44408bf4e9a7c6b6f3f8317fd226bd131435400eff8de7b5f9927ea4aa4c0624cdd3a23630b1b5ab76207adae442e019284e5 |
+----------------------------------------------------------------------------------------------------------------------------------+Related Topics
Last modified: February 27, 2023