SHA1

Hashes the given string or binary data using the so-called secure hash algorithm, version 1. SHA1 has been deprecated as a means of securely signing data.

It is present in SingleStore mainly for backwards compatibility and for systems which require a good enough hashing function and can tolerate collisions. For a more secure hash function, see [SHA2].

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 |
+------------------------------------------+------------------------------------------+

Last modified: February 27, 2023

Was this article helpful?