SHA1
On this page
Hashes the given string or binary data using the so-called secure hash algorithm, version 1.
It is present in SingleStore Helios mainly for backwards compatibility and for systems which require a good enough
hashing function and can tolerate collisions.
Syntax
SHA1(plaintext)SHA(plaintext)
Arguments
-
plaintext: the data to hash.
Return Type
40 lower case hexadecimal digits corresponding to the 160-bit binary hash value.
Examples
SELECT SHA1('ohai'), SHA('ohai');
+------------------------------------------+------------------------------------------+
| SHA1('ohai') | SHA('ohai') |
+------------------------------------------+------------------------------------------+
| dca51952447d80bd35bf631bc21f06648798b7e0 | dca51952447d80bd35bf631bc21f06648798b7e0 |
+------------------------------------------+------------------------------------------+Related Topics
Last modified: February 27, 2023